5 Replies Latest reply on Sep 22, 2011 11:24 AM by blewvelvet

    WOW Simple TEXT Conditional Formatting via the Current Month

    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?