6 Replies Latest reply on Dec 21, 2009 1:49 PM by MJWebster

    Calculation Problem When trying to calculate Date of Enrolment and Date of Discharge

    MJWebster

      Title

      Calculation Problem When trying to calculate Date of Enrolment and Date of Discharge

      Post

      Hi, 

       

      I am building a database for my Boer War Transcribing Project.

       

      Running Filemaker 10.0v3 on a MacBook Pro OS 10.6.2 

       

      Everything is Ok when I calculate the difference between Date of Enrolment (say 1st Dec 1900) and Date of Discharge (say 3rd Dec 1900) = 2 days.. however if I have a date in Date of Enrolment, but nothing is Date of Discharge I get a long useless number.

       

      SO.. how do I get Filemaker to only calculate when there is data in both fields, i.e. Date of Enrolment AND Date of Discharge...

       

      Grateful for any thoughts..

       

      Regards, Malcolm