AnsweredAssumed Answered

Calculation of days between dates.

Question asked by hferrell on Oct 16, 2013
Latest reply on Oct 16, 2013 by 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

      

      

Outcomes