topic Re: Generating last 24 MOnths from today in App Development

Generating last 24 MOnths from today

Rehan — Tue, 26 Mar 2019 18:19:04 GMT

I need to show the last 24 months data. I have defined a variable below and doing a loop

Let vLookbackLength = (month(today()))+24;

For i = -$(vLookbackLength) to -1

But its not giving me the right number of months . What Am I missing here ?

Re: Generating last 24 MOnths from today

Vegar — Tue, 26 Mar 2019 19:01:16 GMT

vLookbackLength = (month(today()))+24;

For i = -$(vLookbackLength) to -1
Trace $(i);
Next i
Will trace -27 to -1 as Month(today()) =3 (March).

Try this instead
For j = 0 to 24 //or 23 depending on if you include current month as one of the 24 months
Let vPeriod = MonthName(today()-$(j));
Trace $(vPeriod);
Next

It should trace all moths from the current to February 2018.