Date constraint in list box

[#1]

Hi Everyone,

I am after an elegant way to populate a list of dates as predefined values in an input box, I need to populate this variable with a format of mmm-yyyy as it's needed in the script to limit data loaded on a monthly basis.

I have setup constraints on the input box and predefined values in the drop-down and listed values with a ; to space them, but I'd like this list updated for a financial year basis +1 month.

Anyone have any ideas?

Thanks

Gavin

[brenner_martina · Accepted solution]

Hi,

you can fill the variable dynamic by using concat in the script. Look at my example!

[#3]

Hi Martina,

This works well in your example QVW, however when I replicate it in another QVW it doesn't work. Any ideas?

I've posted up a test QVW where it's not working.....

Thanks

Gavin

[brenner_martina]

Hi Gavin,

the seperation sign in our German version is Semicolon (;), in your version use Komma (,).

[#5]

Thanks, it now works! I've also worked this into an automatic calendar function and it's what I needed!

Thanks again!