Expression based on Timestamp

[MauriceWhelan]

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 · Accepted solution]

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")

[MauriceWhelan]

hi @LeventK I am getting a Parameter 1 of function HOUR is of the wrong type error

[LeventK]

@MauriceWhelan I have edited the expression in my post. Please check that one.

[MauriceWhelan]

Worked perfectly, thank you @LeventK.