timestamp compare problem

[JonnyZ]

Hi,

If I want to compare the time see if the time is between 17:00:00 to 08:00:00 (night shift),

this statement works,

= if('12:00:00'>'17:00:00', 'Yes', 'No')

But this one seems not,

=if (timestamp(now(),'hh:mm:ss')>'17:00:00', 'Yes', 'No')

where is the problem?

thanks.

[brunobertels]

Hi 

Timestamp is a date AND a time , even if you reduce the format to 'hh:mm:ss' it is still 01/07/2022 hh:mm:ss that you try to compare only with a time.

see below timestamp (now()) give 

Then try this 

if (time#(now(),'hh:mm:ss')>'17:00:00', 'Yes', 'No')