Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
Its better to create this fields in script.
If you do that, this problem will be solved.
Regards,
Kaushik Solanki
Hi,
Its better to create this fields in script.
If you do that, this problem will be solved.
Regards,
Kaushik Solanki
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
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?
Yes you are right.
Regards,
Kaushik Solanki
Thanks er.mohit! Your and Kaushik's solution helped.
Thanks Kaushik! Your and er.mohit's solution helped.