Date Filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a filter so that I can get the last 12 months ending
with the last day of last month.

Example if today is 5-7-06 I would like to return all values between

5-1-05 and 4-30-06
 
Stefan said:
I would like to create a filter so that I can get the last 12 months ending
with the last day of last month.

Example if today is 5-7-06 I would like to return all values between

5-1-05 and 4-30-06
Click to expand...

BETWEEN DateSerial(Year(Date()), Month(Date()) - 12, 1)
AND DateSerial(Year(Date()), Month(Date()), 0)
 
Back
Top