Comparing time in seconds 1

[WynneSMI]

I have a field in a table that has a Date/Time format (General Date, 1/1/2003 12:00:00 AM). I'm calling a function that checks to see if the date/time in the table is less than 10 seconds versus the current date/time. In other words, has 10 seconds elapsed between Now() and the time in the table. How can I compare two date/times with seconds?!? Thanks for any help.

 

[PaulBricker]

Look at the DateDiff function. That should do it.
If DateDiff("s",[datefield],Now()) >10 Then

double check the argument for seconds. I put "s" but it may be some other value.

Paul

 

[WynneSMI]

Thanks! "s" works! The DateDiff gives me what I want!