How to get Month and Year Listboxes working together?

[#1]

Hi,

I have a field called MonthDate ('YYYY-MM-DD', shown on the far right of the image below) and I would like to create two listboxes; one for Year and the other for Month. If you look below, I have done this by using expressions YEAR(MonthDate) and MONTH(MonthDate) on the 2 separate listboxes. Now the issue is that when I select a month, all the values where that month occurs get selected (see the list box on the far right) and when I select the Year (under the impression that my Month value will remain) all the Months are selected.  Please help!

[kaushiknsolanki · Accepted solution]

Hi,

     Its better to create this fields in script.

     If you do that, this problem will be solved.

Regards,

Kaushik Solanki

[er_mohit]

you have to do this in script side like

load Date(Date#(MonthDate ,'YYYY-MM-DD',),'YYYY-MM-DD') as Date,

year(MonthDate) as Year,

Month(MonthDate) as Month

from table;

hope it helps you

[#4]

Good Day Kaushik,

I'm not sure I follow. Do you mean, I leave the MonthDate field and create additional columns, say "Year" and "Month", and use them in my list boxes instead?

[kaushiknsolanki]

Yes you are right.

Regards,

Kaushik Solanki

[#6]

Thanks er.mohit! Your and Kaushik's solution helped.

[#7]

Thanks Kaushik! Your and er.mohit's solution helped.