Criteria to specify date period

[Toble]

Hi

What is the criteria to extract data for the last 12 months starting from the previous month?



Example :
User runs report today (9th July 2015)
Report should only reflect data from June 2014 to June 2015 (i.e. last 12 months data starting from the previous month)

Similarly, user runs report in August 2015.
Report should only reflect data from July 2014 to July 2015

My current criteria, which to extract data for the last 12 months starting from the current month, is

>=DateAdd("m",-12,Date())

Much appreciated

[pbaldy]

That's actually 13 months.

you can subtract 12 months from the first of this month for the start date. A sneaky way to get the last day of the previous month is day 0 of this month, using DateSerial.

[Toble]

That's actually 13 months.

you can subtract 12 months from the first of this month for the start date. A sneaky way to get the last day of the previous month is day 0 of this month, using DateSerial.

would you be able to provide the syntax if it's not too much trouble?