Run report for 15 days in same month but prior year

[MFERNS]

Hi All


I know how to run a report for 15 days of current month in current year but does anyone know how to run a report for the same 15 days of same month in prior year.

Thanks in advance

[MFGF]

Hi All


I know how to run a report for 15 days of current month in current year but does anyone know how to run a report for the same 15 days of same month in prior year.

Thanks in advance

I'm assuming you have a filter based on current_date for your report for 15 days of current month in current year? There is an _add_years() function in Cognos that allows you to add or subtract whole years from a date. You could presumably use a similar expression, but based on _add_years(current_date, -1) to get the same period in the prior year? It's difficult to say for sure without knowing what you are doing currently, though.

Cheers!

MF.