I know I've seen this topic before but I'm looking to go a little farther. What I am trying to do is allow for the user to input a start date and an end date and then click a button that will apply to filter and select only the dates between them. That part is working.
I also want to select the previous year for the same time frame as well.
For example, if the start date is 1/7/2013 and the end date is 1/13/2013, I would like 1/7/13 - 1/13/13 selected as well as 1/7/12 - 1/13/12.
I am using a SELECT IN FIELD action on a button to do this. The current search string is:
='>='&date(vStartDate) & '<=' & date(vEndDate)
That works. Anyone know how to add to that to allow the previous year dates to be selected as well? I have uploaded my sample. !