Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Need to include ""Later Of"" to a set normally calculates ""Earlier Of

I have a set of formulas that calculate a date based on a list of terms in a field. Until now, the terms that had two parts were "the earlier of"  As such, I compared the two results using the "Min" f...
Formulas and functions
AlexCertificati's avatar
AlexCertificati
Qrew Cadet
7 years ago
Can you write out in English the comparison you're trying to write? If Forrest's answer isn't the answer, I don't understand the question.
AlexCertificati's avatar
AlexCertificati
Qrew Cadet
7 years ago
I'm sorry, I don't understand what you are trying to do.

Everything up to 'My problem is' in your comment is fine. But I don't see where you describe the comparison you're trying to write. Again, you have the Min() correctly to calculate the second date, and to calculate the third date you need a Max() for that; it seems that you understand that.

What do you mean by 'calculate both in the same formula'? Can you write out in English the entire comparison you need to do? You calculate the first date, calculate the second date, then you compare the two, then... what?