6 Replies Latest reply on Jan 27, 2014 2:39 AM by Sukant Arora

    How to filter specific hours (or minutes), e.g., 1/27/2014 11:00 to  1/27/2014 14:00

    Sukant Arora

      I want to filter night hours ( say 9 PM to 2 AM) to show specific locations visited by a person. I have made a calculated field on date time field ("Time of Day") as shown below:

       

      IF (DATEPART ('hour', [Time of Day] )>21 and DATEPART('hour',[Time of Day] )<2) then [Time of Day]

      END

       

      But its not working. In description, value shown is null.

      Any suggestions?