How to get only last 12 months data

[Reghita]

I got a report that calculates the total number of calls received for each months using cross tab format.

But I only need to get the last 12 months data from last month. Does anyone know how can I do this?


RB

 

[Madawc]

Do you mean every date between the last day of last month and first day of a month 12 months before that? If so, you could get the start of the current month, First_This, as:
datetime (datepart("yyyy", CurrentDate),
datepart("m", CurrentDate), 1)
Then get Last_Month, the last day of last month:
DateAdd ("d", -1, First_This)
Then get Last_Year
DateAdd ("yyyy", -1, First_This)

Select dates that are between Last_Year and Last_Month, inclusive.

Madawc Williams
East Anglia, Great Britain