AnsweredAssumed Answered

Missing data in calculated date fields

Question asked by dominicjoannou on Oct 8, 2016
Latest reply on Oct 9, 2016 by Johan Hedman

Hi I am new to the Filemaker Community.  I am having difficulty with missing dates in date fields and the subsequent calculations. I am trying to calculate date of referral to date of interim hearing which is "interim hearing - date of referral". The majority of the dataset's date of referral is not known.  I don't want any figure the field of time from referral to interim hearing if there is no date of referral. Many thanks Dominic