This content has been marked as final. Show 2 replies
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?