2 Replies Latest reply on Jan 25, 2012 12:24 PM by Brae

    I want Case to produce an empty field

    Brae

      Title

      I want Case to produce an empty field

      Post

      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?