That would depend:
"Were you late (today/yesterday/this morning)?" is correct for one specific time.
"Are you (always/usually) late?" is correct if you are asking about that person's habit of being late. It could also imply that it bothers you.
There are more possibilities, depending on different contexts.