With our VA reporting we derive a "month counter" before loading the data into the LASR / CAS server. Current month = 0, last month = 1, two months back = 2 and so on. Next month is tagged -1. That way a VA static filter of "month counter" = 0 will always get the current month and no date formulas are required. This is how we create the counter:
* Derive reporting month counter, latest month = 0, previous month = 1 and so on.;
Reporting_Month = intck('MONTH', Reporting_Date, today());
... View more