Does anyone know of a way in a query to have criteria that takes [date] as a parameter, and returns the date but with a year less than what was typed. For example I type in 1/6/02 and it returns 1/6/01.
I can have a [date]-365, but that doesn't work. I need the exact date from the previous year. Thanks alot.
I can have a [date]-365, but that doesn't work. I need the exact date from the previous year. Thanks alot.