AnsweredAssumed Answered

I want Case to produce an empty field

Question asked by Brae on Jan 25, 2012
Latest reply on Jan 25, 2012 by Brae


I want Case to produce an empty field


Hi. I am using Case to produce due dates for medical certification based on the age of people and the date they were last certified. This is all working fine, except for the last part: I want the result field to remain empty if the medical date field is empty. So it looks like this:

Medical Due Date = Case ( Age  > 50; Medical Date + 365 ; Age  ≤ 50 and Age  > 30 ; Medical Date + 730 ; Age ≤ 30 ; Medical Date + 1825; IsEmpty (Medical Date); "")

I have this set up as a Calculation field and the result required as a that my problem, and if yes is there a workaround?