Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to add a background color based on whether a timestamp is before or after 12:00PM. If the timestamp is before 12:00PM, the background color will be Red(). If the timestamp is after 12:00PM the color will be Green(). The issue is how do I evaluate the timestamp to compare to my standard of 12:00PM? Below is what I came up with, but it's not working. I know the issue is in the "Timestamp('12:00','hh:mm')," portion of the expression. Thank you in advance for any assistance on this issue.
If(Timestamp(Date ,'hh:mm')<=Timestamp('12:00','hh:mm'),Red(), Green())
If Date is a datetime field then trying frac 'ing it :
If(Timestamp(frac(Date ,'hh:mm'))<=Timestamp('12:00','hh:mm'),Red(), Green())
maybe with hour
if(hour(date) <= 12, ..., ...)
You need to convert the TimeStamp in Time Format before comparing...
=If(Time(Frac(TImeStamp(NOW())),'hh:mm')>=Time#('12:00','hh:mm'),GREEN(),RED())
Use your TimeStamp Field instead of NOW()
That did the trick. Thank you Massimo!!
Thank you Manish. I can use this on other apps.