AnsweredAssumed Answered

Calculation of days between dates.

Question asked by hferrell on Oct 16, 2013
Latest reply on Oct 16, 2013 by hferrell


Calculation of days between dates.


     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“.