AnsweredAssumed Answered

Date Field Calculations

Question asked by dominicjoannou on Oct 9, 2016
Latest reply on Oct 9, 2016 by keywords

Hi All,

 

I have tried the suggestion below with:

 

If (IsEmpty (Date of Referral to Regulatory Body);  "";  (Date of Interim Sanction) - (Date of Referral to Regulatory Body)) or

 

Case(

  not IsEmpty(dateReferall) and not IsEmpty(dateFinal), dateFinal - dateReferral;

  not IsEmpty(dateReferall) and not IsEmpty(dateInterim); dateInterim - dateReferral;

  GetAsNumber("")

 

I have tried:

 

Let command instead of Case(

 

I have also tried reclassifying the fields as already suggested.

 

Through the command line in blue, the field of Date of Referral to Regulatory Body is ignored.

 

However, a lot of people go directory onto their Final Sanction after referral. They do not have an Interim Sanction. This leaves the Interim Sanction field blank.

 

Where I have managed the suggestions in italics and reclassifying fields, it comes up with 0 and 1; which is useless to me, because I am trying to measure time.

 

I use Filemaker 13 Pro. Maybe I am asking too much from this package and the options are cleaning the data in either Excel or Stata.

 

Many thanks

Outcomes