2 Replies Latest reply: Jan 23, 2012 12:34 AM by Mohammed Rend RSS

    filter listbox of year to display all record of the current year and previous

    Mohammed Rend

      Hi everyone,

       

      I have a listbox that capture the years of hired date and displays it in horizontal view. So If you click on a year it will display all employee hired on that current year.  But I want it to display all the employees of the current hire and the previous the years.  Example is attached

       

       

       

      Here's my code

       

       

      Load 
       HireDate,
       Year(HireDate) as Year 
       Month(HireDat) as Month
      
      From
      myexcel.xlsx
      
      
      


      From here I created two list box , one for Year and the other for Month.

       

      Thanks