Rolling Date Restrictor

[ChuckW]

Hi,

How do I do a date restrictor for the past calander year
on a rolling basis? I am running a weekly report and
want to get sales for the past year and have this on a
rolling basis?

Thanks,

Chuck

 

[Peter R. Fletcher]

The criterion in the Query column for Sale_Date would be:

Between (Now() - 365) and Now()

If you want to be slightly more persnickety, you can use DateAdd
("yyyy", -1, Now()) as the from date to go back exactly a year, even
in Leap Years!

Hi,

How do I do a date restrictor for the past calander year
on a rolling basis? I am running a weekly report and
want to get sales for the past year and have this on a
rolling basis?

Thanks,

Chuck

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher