3 Replies Latest reply on Jul 6, 2016 12:38 PM by Shinichiro Murakami

    How to use a specific DateTime as datetime range Quick Filter?

    owen walker

      So as the title says.

       

      I have a datetime range quick filter setup in the book which will allow the user to adjust the working day to a specific time.

       

      The issue is each "step" as they adjust it will work based off the time being 00:00

       

      The working day for this data however is from 06:00 to 05:59 the following day.

       

      I've managed to get it to give the start and end dates of the data as 06:00 using a calculated field as the filter:

      MAKEDATETIME(DATE([Log Time]),#06:00:00#) (Log_Time is a DD MM YY HH MM SS value in the data)

       

       

      However when they adjust the sliders it returns to times of 00:00

       

      Is what I'm asking for possible the way I'm trying to do this or am I thinking about it the wrong way?

       

      Thanks for any assistance, and if there is any confusion please let me know!

      Owen