6 Replies Latest reply on Dec 2, 2013 11:44 AM by Matt Lutton

    Max Date Function not calculating correctly

    Kate Lemieux


      I have a string field which has dates in it but when I use the Max function it does not calculate correctly.  It is bringing me back a 11/22/13 date but there is a 1/15/14 date also in the field - it appears to not recognize the year.

       

      If ISNULL(MAX([PENDate])) = True THEN "-" Else MAX([PENDate]) End