If you use a datetime type then you can compare against datetime().


>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