AnsweredAssumed Answered

Help with Date Evaluation Calculation

Question asked by KristineZoltek on Aug 18, 2011
Latest reply on Aug 18, 2011 by KristineZoltek


Help with Date Evaluation Calculation


I have three date fields.  For all intents and purposes lets call them "Date 1" "Date 2" and "Date 3."  I need to write a calculation for a field that evaluates which of the three is the earliest date, and returns the value of the field with the earliest date.  I need it to evaluate and return a value even if one, or two of the three fields are empty.  I don't write often, am sure this has been done many times before, and hope you may be able to quickly help. 

Thank you.