AnsweredAssumed Answered

Calculating number of days between events

Question asked by VictorMontori on Dec 29, 2014
Latest reply on Dec 30, 2014 by VictorMontori


Calculating number of days between events


I am trying to figure out how to calculate the number of days between events and if one of the events is blank, it does not calculate.

I have the following fields (some of which may be left blank as it is not related to this project): 
Start date, completion date, deadline date, plan started, grant started on, execution date, publication date

I would like to calculate: 
Start date to execution
Start date to publishing
Start date to deadline
Start date to grant
Execution date to publishing date

Right now when I enter only a start date and deadline date (leaving other fields blank), it automatically fills in -735415 for the other fields.  I would like the field to be blank.  

I have the calculations set up correctly as if I fill in every field, the calculation is correct.  It is just when I leave something blank it enters the negative number. 

Can someone help me?  Please let me know if I need to clarify something.  I have attached a picture if that helps.  

Thank you

Kirsten assistant to Victor