COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: peewan on 01 Apr 2020 11:42:06 AM

Title: How to get previous year First day of last month in cognos relational model?
Post by: peewan on 01 Apr 2020 11:42:06 AM
How to get previous year First day of last month in cognos relational model?

Example:
I have report run 1/1, 2/1, 3/1 - 2020 base on 12/1/2019, and want to schedule it run for every year.
Title: Re: How to get previous year First day of last month in cognos relational model?
Post by: BigChris on 02 Apr 2020 01:54:33 AM
_first_of_month
_add_years
_add_months

are the functions that you need to use