Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, Im new to this and looking for a little help.
I have a variable and i am trying to have a variable input list box amend that, please can somebody advise on how i could automatically have the list box populate the first day of the month for the last 12 months?
I have tried using something like Floor(MonthStart(date(Todate()))) however if i try to build a list upon this it says anything after | is garbage.
hi @Rogers2212 ,
I hope this is helpful to you.Try this script
Let vMinDate = NUM(Date('01/01/2020','DD/MM/YYYY'));
Let vMaxDate = NUM(Date('01/12/2020','DD/MM/YYYY'));
TempCalendar:
Load
AddMonths($(vMinDate),IterNo()-1) as TempDate
AutoGenerate 1
While AddMonths($(vMinDate),IterNo()-1) <= $(vMaxDate);
output:
Regards,
Raji