I need help with a query on one of my tables. On one of the table fields there is a date mm/dd/yyyy. I need to have the user input a future date and then count back 6 years from the table field date. I only want to see the dates that fall in the 6 year window.
ex: user input - 06/01/2015
the query would pull only the dates starting 06/01/2009 to 05/31/2010