Date parameter

D

Derek

How Would I go about setting up a parameter that would poll the last 24hrs, I was thinking one might be able to utilize the Now function but not sure.
 
D

Duane Hookom

A criteria of Now()-1 will retrieve date values less than 24 hours old.

--
Duane Hookom
MS Access MVP


Derek said:
How Would I go about setting up a parameter that would poll the last
Click to expand...
24hrs, I was thinking one might be able to utilize the Now function but not
sure.
 
D

Duane Hookom

For today:
DateValue([YourDateField]) = Date()

For Yesterday:
DateValue([YourDateField]) = Date()-1
 
Top