AnsweredAssumed Answered

WOW Simple TEXT Conditional Formatting via the Current Month

Question asked by blewvelvet on Sep 22, 2011
Latest reply on Sep 22, 2011 by blewvelvet

Title

WOW Simple TEXT Conditional Formatting via the Current Month

Post

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.

I've tried

 

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...

Any ideas?

Outcomes