DateTime valid If

[vhan_fire]

Hi how do I do the valid if formula for “if time[this_] > 9pm” note that [this_] is datetime it always return to some date in 1899. I want to only validate the time.

[Steve]

Try:

(TIME([_THIS]) > "17:00:00")

See also:

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

help.appsheet.com

TIME()

Time from Date, DateTime, or Time