AnsweredAssumed Answered

Calculating number of days between events

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

Title

Calculating number of days between events

Post

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

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

Filemaker_example.PNG

Outcomes