Author Topic: How to get previous year First day of last month in cognos relational model?  (Read 41 times)

Offline peewan

  • Senior Member
  • ****
  • Join Date: Aug 2019
  • Posts: 59
  • Forum Citizenship: +0/-0
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.

Offline BigChris

  • Statesman
  • ******
  • Join Date: Apr 2013
  • Posts: 1,206
  • Forum Citizenship: +86/-0
_first_of_month
_add_years
_add_months

are the functions that you need to use

 


       
Twittear