4 Replies Latest reply on Nov 8, 2016 1:40 AM by sanganabasav.hanjagi

    Setting a date range based on a separate table of date range values

    siyang.teo

      I have a table of date ranges in the below format.

      How can I insert this as a quick filter / parameter, such that when I choose a month, the date will be restricted to the Startd-Endd by month?

       

      I only know the possibility of using two list date parameter and inserting startd & endd fields. But this does not restrict the start-end dates by the specific months and have to be manually selected.

       

      Attached sample workbook in v10.

       

      Thank you.