Return Records for last 5 years 1

[Lavenderchan]

Hello,

I am trying to return records for the last five years with out using specific dates. I have figured out how to return one year by using the formula

 Year(Date)))

. I can also return records by from 5 years using

Year(Date))-5

. However its only returning records for that specific year. How do I combine them using Between And. What I have used is not working.

 

[dhookom]

Last 5 years could be all of 2015 to today:
[pre] Year([YourDateField])>= Year(Date())-5[/pre]

If you want the equivalent of 5 years based on the current date:
[pre] [YourDateField] > DateAdd("yyyy",-5,Date())[/pre]

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016