6 Replies Latest reply on Apr 17, 2017 2:31 PM by Justin Larson

    Max of two Date Fields - When one is null the Formula gives me a null value instead of the MAX

    Charles Kealy

      So I have two date fields.  I'm trying to pull only the max.  When I use the MAX formula however on instances where one field is blank, instead of giving me that MAX date, it gives me a Null value.

       

      Can anyone help me with this?  My file is unfortunately 80 MB so I can't attach it.  Thank you!