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?