Hello,
I have been searching for some way to do this for a while now, but nothing has come up exactly this way...
In my QVW, I basically need to create a separate table where I can have the last 12 months from a date variable I store in the document...
varMyDate = 9/26/2012
RollingCalendar:
9/1/2012
8/1/2012
7/1/2012
6/1/2012
5/1/2012
4/1/2012
3/1/2012
2/1/2012
1/1/2012
12/1/2011
11/1/2011
10/1/2011
It is OK if I need to do this in the load script.. I just cannot figure out how this can be done. Initially it seemed like an inline load would work, but that uses literal values so I cannot use Date functions.
