I have a query that uses the parameter between [start date] and [end date], and I need to add a modification that changes the year to the year before. Something like:

DateAdd ("yyyy",-1,Between [start date] and [end date])

This returns an error of course but you hopefully get my idea. Anyone have any suggestions?

Thanks so much in anticipation.

Between DateAdd("yyyy",-1,[start date]) and DateAdd("yyyy",-1,[end date])