return all data from last 5 years from today's date

  • Thread starter Thread starter Attila Fust
  • Start date Start date
A

Attila Fust

I want to run a query so it will give me all data from the
last 5 years from today's date without having to specify
the actual dates.

Is there a way to do this?

Thanks,

attila fust
 
I want to run a query so it will give me all data from the
last 5 years from today's date without having to specify
the actual dates.

Is there a way to do this?
Click to expand...

Easily: a criterion of

BETWEEN DateAdd("yyyy", -5, Date()) AND Date()
 
Attila,

Use a criteria like this...
Between DateAdd("yyyy",-5,Date()) And Date()
.... or, if there are no records in your data with future dates, this may
suffice...
 
Back
Top