7 Replies Latest reply on Oct 16, 2013 7:20 PM by hferrell

    Calculation of days between dates.

    hferrell

      Title

      Calculation of days between dates.

      Post

           Simple enough--except when one of the dates is missing.  If one date is missing, the result is an extraneous number like +/- 733810. 

           If date/dates are not complete, how can I get the results of the calculation to be “Unknown” rather than getting an extraneous number? 

           Having the actual date is not possible in some cases.  Sample calculations: 2009-2006= 0; No Date-1/31/2009= 733437; 5/17/2010-1997= 733909; 9/1/2009-No Date= -733651; No Date-No Date= “Blank“.

           Thanks,

           Hal