2 Replies Latest reply on Oct 9, 2016 7:56 AM by Johan Hedman

    Missing data in calculated date fields

    dominicjoannou

      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