1 Reply Latest reply: Jul 10, 2014 12:58 PM by Nestor Ramirez RSS

    Using date input box and list boxes to filter date ranges

    Tim Cooper

      Hi there,

       

      I'm working on a dashboard which provides users with multiple filtering options.  Currently users can filter dates by Year, Quarter, Month, Week and Day of Week using various list boxes.  What I have been asked to add is the ability to enter in a specific date range on top of this.

       

      The fields used in the list boxes are contained within a date look up table which is joined to specific date field within the main data set e.g I'm not calculating Year(Field_Name) I'm actually using specific fields so:

          

           Date Lookup Table:

           Year

           Quarter

           Month

           Week_Number

           Day_of_Week

           Source_Date (which is joined to Operation_Date in the main dataset)

       

      What I need to be able to add is an input box or calendar object which allows the user to input a start date and end date (also linked to Operation_Date) whilst also keeping the List Boxes.  I have seen some examples of how to set up a date range using variables but I don't know quite how to do this when needing to also keep list boxes in the scenario.   Any help would be appreciated.