Date Restrictor

[ChuckW]

Hi,

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

Thanks,

Chuck

 

[Brian Camire]

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

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().