Any Ideals on How to set up a current date and same day Last Year
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.
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!