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 Date....is that my problem, and if yes is there a workaround?