If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Display Last Year's Date

Started by AnthonyJ, 02 Mar 2010 12:19:31 AM

Previous topic - Next topic

AnthonyJ

I am trying to display last year's date based on the current date. I used a layout calculation and tried using the following syntax but getting a parsing error -

_add_years(current_date,-1)

_add_years(Today(),-1)


Any ideas ?


CognosPaul

The _add_years function needs a timestamp, not a date which Today returns. Try this instead: _add_years(date2timestamp(Today()),-1)

AnthonyJ