1 2 Previous Next 15 Replies Latest reply on Oct 21, 2013 9:58 AM by steve_c

    Conditional Formatting and Current Date



      Conditional Formatting and Current Date


           I have been trying for over an hour to change a date field to red if it is less than the current date but am struggling.

           I am in layout mode, edit layout, done a right click on the field, then picked (conditional formatting) and i have tried to add both a (value is) and (formula is) using my field "Refresher_Date" with <Get(CurrentDate) but it appears to change all my dates to red irrespective of being below or after the current date.  Am I missing something obvious here, should I caryout this task in another mode?

        1 2 Previous Next