WOW Simple TEXT Conditional Formatting via the Current Month
I can't believe I'm having such a hard time figuring this one out.
I have each month in a separate Text on a layout and abbr. each month. e.g.
JAN FEB MAR APR...
I would like to conditional format each one to change color based on the current MONTH. I even have a global field of aPROJECTS::TODAYS DATE that is updated daily by another script
I've tried various conditionals. You would think this would be simple.
Get ( CurrentDate ) = MonthName ( SEPTEMBER )
aPROJECTS::TODAYS DATE = (*9/**/****)
aPROJECTS::TODAYS DATE = Date ( 9 ; * ; 11 )
GetAsText ( SEP ) = Month ( 9 )
I've even tried using variation of these and so on.
This has to be simpler...