One solution would be to use an integer field and storing the time expected as the number of seconds since midnight, using Seconds().
So, let say that they are required to punch in before 9:00AM:
REPLACE TimeExpected WITH 9*3600
...
IF TimeExpected < Seconds()
ENDIF
HTH
>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()?