This content has been marked as final. Show 6 replies
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!