Answer Question
How to calculate a previous month value using Magic variable [CURRENT_MONTH]?
Hi
I would like to add a filter to a report which one of the report criteria is to retrieve data in date range between 26 of previous month and 25 of current month. May I know how to generate this date range every month automatically?
For report end date, I can specify "[[CURRENT_YEAR]]-[[CURRENT_MONTH]]-25" as the report end date in the filter. However, I am unable to create same for the report start date. If I specify [[CURRENT_MONTH]] - 1, it return "11 - 1" instead of 10 (current month is 11)
Would you please advise how to resolve my problem please? Thanks.
I would like to add a filter to a report which one of the report criteria is to retrieve data in date range between 26 of previous month and 25 of current month. May I know how to generate this date range every month automatically?
For report end date, I can specify "[[CURRENT_YEAR]]-[[CURRENT_MONTH]]-25" as the report end date in the filter. However, I am unable to create same for the report start date. If I specify [[CURRENT_MONTH]] - 1, it return "11 - 1" instead of 10 (current month is 11)
Would you please advise how to resolve my problem please? Thanks.