Solved: Expression based on Timestamp - Page 2

MauriceWhelan · 08-02-2019 03:17 PM

Hi

I need to set an initial value of a field based on my Timestamp being before 10am. Not sure of the syntax. Could someone help?
The inital value of the timestamp field is NOW() format. e.g. 16/07/2019 14:24:34

Thank you.

LeventK

Provided I have understood you correctly:

IF(HOUR(TIMENOW() - "00:00:00")=10,"if TRUE This Value","if FALSE This Value")

Provided you want to make the comparison as per your [Timestamp] column, use this expression:

IF(HOUR(TIME([Timestamp]) - "00:00:00")=10,"if TRUE This Value","if FALSE This Value")

View solution in original post