Date Restrictor

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

Can someone tell me how to do a date restrictor that will
capture transactions between 60 and 90 days.

Thanks,

Chuck
 
If you have a Date/Time field and you want to select records where the value
is between 60 and 90 days ago, you might set the criteria on the field in
query design view to something like:

Between Date()-90 And Date()-60

or, if you, mean less than 90 days ago but greater than or equal 60 days ago
Date()-90 And <= Date()-60
Click to expand...

If your field contains the time of day (in addition to the date), and you
want to count backwards starting from now (instead of midnight this
morning), use Now() instead of Date().
 
Back
Top