Calculation Problem When trying to calculate Date of Enrolment and Date of Discharge
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..