« previous next »
Pages: [1]

Author Topic: Current Date and Same Day last Year in Framework Manager  (Read 1149 times)

Offline coledog

  • Full Member
  • ***
  • Posts: 31
  • Forum Citizenship: +0/-2
Current Date and Same Day last Year in Framework Manager
« on: 18 Sep 2006 08:29:45 am »
Any Ideals on How to set up a current date and same day Last Year
Logged

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Posts: 3,112
  • Forum Citizenship: +153/-3
  • Cognos Software Muppet
Re: Current Date and Same Day last Year in Framework Manager
« Reply #1 on: 18 Sep 2006 08: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.
Logged
Meep!

Offline Rico

  • Full Member
  • ***
  • Posts: 5
  • Forum Citizenship: +0/-0
Re: Current Date and Same Day last Year in Framework Manager
« Reply #2 on: 26 Sep 2006 08: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!
Logged
Pages: [1]
« previous next »