AnsweredAssumed Answered

Calculation Field

Question asked by storywizard on Jun 23, 2010
Latest reply on Jun 23, 2010 by 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

 

 

Outcomes