2 Replies Latest reply on Jun 23, 2010 9:12 AM by storywizard

    Calculation Field

    storywizard

      Title

      Calculation Field

      Post

      Hello all:

       

      I have a  question.

       

      I have this formula for the status field in my layout:  

       

      Case (IsEmpty (PartCompDate) and (PartDueDate ≥ Get (CurrentDate));"In Process";
               IsEmpty (PartCompDate) ; "Over Due" ;
               PartCompDate  ≤ PartDueDate ; "Complete")

       

      Is there anyway that I can leave my status field blank  when there are no dates entered in PartCompDate and PartDueDate?

       

      Storywizard