Solved-How to have a cognos report display data from current date to previous yr

[xyz]

Hi Gurus,

I am using Cognos 10.2.1 and data source is relational, I have a date field from data base and have a requirement to display report from current date to previous year January.

Example:

If my report is running today, then report should have data from today's date i.e. 03/06/2015 to 01/01/2014.

Currently I have a date condition in the filter like below. Which is giving only data for one year from current date to previous year 03/06/2014. How will I get above requirement.

[Date Column] between _add_years(current_date, -1) and current_date.

Can some one please let me know, your help is much appreciated.

Thanks & Regards,
XYZ

How will I get the pr

[BigChris]

how about something like:

[Date Column] between _make_timestamp(year(current_date)-1, 01, 01) and current_date

[xyz]

A big Thanks to you for your quick response Big Chris.

I really appreciate the help.


Thanks & Regards,
XYZ

[BigChris]

You're welcome - did it work?

[xyz]

Yes, it worked.

I forgot to mention that though :)





Thanks & Regards,
XYZ