Change Background color IF Time is late

[rustyfishbones]

Hi All,

I have the following to change the color if a finish time is greater that 17:00, however it's not working

my variable is working fine as it is returning the correct finish time, but the color is not changing

Any ideas?

Regards

Alan

[sreenivas]

check the Format of the variable

[#3 · Accepted solution]

What if you did like this:

if(Hour($(estimatede.finish.time.picking)) >= 17.red(),green())

[amit_saini]

Hi Alan,

Write this script over here:

Thanks

AS

[#5]

hi

try to keep both in same format.

or try this

if(num(time('=$(estimated.finish.time.picking)','hh:mm:ss')'))>=num(time('17:00:00','hh:mm:ss'),Red(),Green())

[rustyfishbones]

Thanks Thomas,

I should have known to try that!!

Regards

Alan

[#7]

Is it possible that estimated.finish.time.picking holds whole date while 17:00:00 doesn't?

I'd probably go for numeric comparison instead of strings

[MK_QSL]

=IF(HOUR(NOW())>9,Green(), RED())

Change as per your requirement and fields