2 Replies Latest reply on Nov 17, 2014 10:09 AM by fmpdesign

    conditional formatting difficulty



      conditional formatting difficulty


      Hello folks,

      I'm trying to format a date field so that any record in which that field contains a date equal to or earlier than today's date will have the date displayed in red.  Using Conditional Formatting, I've begun the Condition with "Value is <=".  I've tried completing the Condition with Get(CurrentDate) and a variety of other entries, none of which seems to have the desired effect.  Might somebody know how I can accomplish my goal?  Any assistance would be much appreciated.  Thanks