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

 

Current Date and Same Day last Year in Framework Manager

Started by coledog, 18 Sep 2006 09:29:45 AM

Previous topic - Next topic

coledog

Any Ideals on How to set up a current date and same day Last Year

MFGF

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.
Meep!

Rico

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!