List of dates within a listbox

[Rogers2212]

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.

[raji6763]

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