I am creating a little application but have come across an interesting situation. This app will simulate an In/Out board, where employees will check in or check out. If they check out they will enter a time they are expected in. I will have a timer that will occasionally run it will do the following:

if user is out
if time expected in < time()
Send them an e-mail reminding them to check in

The question is, what field type should my time expected in be?

Datetime? If so, how do I check the entered time against time()?

TIA!

Rob