Last Year To Date by Month

[shricky]

I am using Cognos 8, what function do I use or query calculation do I write to return last years data for a particular month? For example, I am trying to compare this years sales this month (current month) to last year's sales, this month last year. Since this month is May, I want to see May/2007 data and May 2006 data.

Thanks for your help.

 

[blom0344]

Based on today , 22 may:

_first_of_month(add_months(_add_years(current_date;-1)))

will yield 1-6-2006 00:00:00

_first_of_month(_add_years(current_date;-1))

will yield 1-5-2006 00:00:00

Any date/timestamp between these values will yield may 2006


Ties Blom