2 Replies Latest reply on Dec 30, 2014 7:43 AM by VictorMontori

    Calculating number of days between events

    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