Quering LAST 3 FULL YEARS

[tmanDuer]

Hello all, I have a table called 'TblApplications' where I would like to bring records back from the previous full 3 years only. So, this being 2017, I would like to run a query and bring back only (and all) records from 2016, 2015, 2014. My field name is 'applydate' with of course other fields related to when someone applies(name, DOB, etc)



I have
Select...... Where (((applydate) Between DateAdd("yyyy",-3,[Forms]![frm_Apply]![Start Date]) And [Forms]![frm_Apply]![End Date]....

As you can see this bring back the last 3 years of data Between the 'Start Date' and 'End Date' The start and end date are something that the user has already added in from the frm_apply form. I was hoping to use the date already in place so the user would have to do anything else except click the 3 year report button.

As I am typing this I realize I may not have done a great job at explaining, but I think you might get the jest... In current year, how to you query for just the last 3 full years of data.

Thank you so much, I appreciate any help!

TmanDuer

[JoeM]

Try this:

Between DateSerial(Year(Date())-4,1,1) And DateSerial(Year(Date())-1,12,31)

[tmanDuer]

I tip my hat to you, JoeM! This works perfectly. THANK YOU!

[JoeM]

You are welcome.