6 Replies Latest reply: Jul 22, 2013 9:22 AM by aquilaquilz RSS

    How to get Month and Year Listboxes working together?

      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!