Wanting to use a rolling 3-year period for collecting some stats, I tried the following construct:
NumTotalCycles = 4;
StartDate = 2013+(TotalCycles-1)*2;
EndDate = 2015 + (TotalCycles-1)*2;
However, even though StartDate and EndDate DO change from cycle to cycle, the actual data period sampled does not, it remains 2013-2015 throughout.
Can this behavior be modified to work as expected?
Would greatly appreciate.