2 Replies Latest reply: Aug 15, 2017 11:27 AM by Eduardo DImperio RSS

    Expression Based on Time

    Mark Ritter

      I have a date time field called OnSceneTime.

       

      I need to strip out just the time (hhmm) and then compare this to a fixed value to see if the call was made on time or not.

       

      For example I have a range of 1200-1500 (12 - 3 PM).  If the OnSceneTime is between these times then it was on time.  If it was after 3PM then it was late.

       

      What is the best way to do this?