Selecting records 11 months prior to StartDate
Posted on 2014-02-11
I have created a query with the following criteria and based on a table with the fields [StartDate] and [EndDate]…
Between DateAdd("m",-11,[StartDate]) And DateAdd("m",-1,[EndDate])
If I set the [StartDate] on 01/01/2014 and the [EndDate] on 31/01/2014, I get the correct records returned starting 01/02/2013 to the 31/12/2013 (11 months). However, if I set the [StartDate] to 01/02/2014 and [EndDate] to 28/02/2014 my query will only return those records from the 01/03/2014 to the 28/01/2014.
I would really appreciate some help on how to change the criteria to include records to the last day of the month for the [EndDate] (31/01/2014)? I've searched extensively and can't find anything that is helping.