AnsweredAssumed Answered

Conditional Formatting and Current Date

Question asked by steve_c on Oct 20, 2013
Latest reply on Oct 21, 2013 by steve_c


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?