topic Re: List of dates within a listbox in App Development

List of dates within a listbox

Rogers2212 — Sat, 16 Nov 2024 01:57:06 GMT

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.

Re: List of dates within a listbox

raji6763 — Wed, 08 Jul 2020 13:21:33 GMT

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