COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Framework Manager => Topic started by: coledog on 18 Sep 2006 09:29:45 AM

Title: Current Date and Same Day last Year in Framework Manager
Post by: coledog on 18 Sep 2006 09:29:45 AM
Any Ideals on How to set up a current date and same day Last Year
Title: Re: Current Date and Same Day last Year in Framework Manager
Post by: MFGF on 18 Sep 2006 09:38:05 AM
Two calculations.

1. Add a calculation using the current_date function as its expression.
2. Add a calculation using both the _add_years and current_date functions i.e.
_add_years(current_date,-1)

These could either be embedded within a Query Subject or Stand-alone (perhaps in a folder).

Best regards,

MF.
Title: Re: Current Date and Same Day last Year in Framework Manager
Post by: Rico on 26 Sep 2006 09:01:36 AM
Be sure of what you think of what is the same day in the last year.

Is it the day minus 365 days?
Is it the same day and month minus one in the year number?
Is it the same weekday in the same iso calendar week one year ago?

It sounds trivial but can make significant differences!