6 Replies Latest reply: Nov 13, 2014 4:44 PM by Marco Wedel RSS

    Using Dates in an expression

      Hi,

      I am trying to use a date formatted MM/DD/YYYY and compare it to today's date in an expression.  I would like to have all dates before the current date flagged and all the dates after the current date to remain unflagged.  The expression that is not working for me is as follows:

       

      if( DateField < Today(), 1,0)

       

      I'm just trying to flag all dates before today as 1, all dates after today as 0.

      Any help would be greatly appreciated.