Rolling Date Restrictor

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

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
 
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
Click to expand...


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