Forum Discussion
Conditional Formatting Past Due Date
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:
It should be :
FormatColour = IF(Today() >= [Date_due], "Red")
tells us if it works
I'm sure that would work. But I'm still getting an error:
says my DATE_DUE doesn't exist. Even though it does:
Your probem is that your're creating a measure and you should use a column for this formula. So it is not because your column doesn't exist, it's because a measure doesn't have a row context whereas the column will have a row context.
So if you create a new column (not measure) with the same formula it should work.
Let us know