Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
for Each date in '7/2016','6/2016','6/2015','6/2014','6/2013','6/2012','6/2011','6/2010','6/2009','6/2008','6/2007','6/2006';
i want the dates in a variable so that i can access it like
for Each date in $(vDate)
Thanks in advance
Hi,
You could do something like this:
data:
Load
Date#(Date,'M/YYYY') as FormatedDate;
Load * Inline
[
Date
'7/2016'
'6/2016'
'6/2015'
'6/2014'
'6/2013'
'6/2012'
'6/2011'
'6/2010'
'6/2009'
'6/2008'
'6/2007'
'6/2006'
];
for each dateVal in FieldValueList('FormatedDate')
trace $(dateVal);
next;
This will only show all the dates on the reload popup, but you can start from this.
thank you Felip Drechsler for the solution
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .