11 Replies Latest reply on Sep 25, 2018 8:03 AM by Jonathan Smith

    How to create Separate Date and Time range filters from one DateTime Field

    Heather Johnson

      I have a datetime field in my data source. I am trying to create filters to allow users to select ranges of dates and times (shifts) to view data for those specific ranges.

       

      For instance:

       

      The want to see data for the last three days between the hours of 6am - 4:30pm.

       

      I have created the Date range filters, but am not sure how to create the Time range filters using the same field. For the start date and end date I created a parameter than connected a calculated field. Haven't been able to duplicate this process using just the time. In the Parameters dialog box there is a selection for Date and DateTime but not just time.

       

      Any suggestions or examples?

       

      Thanks!

       

      ~Heather