Date/time 10 minutes before the now() time.

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi All,

I want to run a query that will gather data 10 minutes from the now
date/time. How can I do this without having to write the date/time in there
myself?

Mark
 
Hi All,

I want to run a query that will gather data 10 minutes from the now
date/time. How can I do this without having to write the date/time in there
myself?

Mark
Click to expand...

10 minutes before or 10 minutes after the Now time?

10 minutes before now?
As criteria on the Date field, write:
Between Now() and DateDiff("n",-10,Now())

10 minutes after now?
Between Now() and DateDiff("n",10,Now())
 
theDateTimeField BETWEEN DateDiff("n", 10, now( )) AND now( )



Vanderghast, Access MVP
 
Ahhh. Thought about a difference, but it is an addition....

DateAdd("n", -10, now( ) )

instead of DateDiff...


Vanderghast, Access MVP
 
Back
Top