Forum Discussion
Solved
Conditional Formatting Past Due Date
I want to show font color (Red) if the Due Date is Today or before today. Table name is TR_FSP_2 column is Date_Due. Case Name Date_Due Smith, j 10/06/2020 x, Greg 11/07/2022 Harris ...
It should be :
FormatColour = IF(Today() >= [Date_due], "Red")
tells us if it works
If you're running it on your PC or on a server within the same time zone as yours, TODAY() is fine and so you don't need that part, just TODAY().
Otherwise replace by a value (ie 7 if you're 7hrs ahead of US and your report will be published on a US Server)
I am running on my computer for my time zone. So if I take it out (timezoneOffset / 24). Should I also take out todayInYourTimeZone?
I tried:
FormatColour =
var = TODAY ( )
return IF(Today >= [Date_due], "Red")
And get sytax error:
