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.
ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago
Currently, it calculates like this...
*1st Formula Field: If the term is X, calculate the single term or the 1st half date for [MSO Delivery Deadline1]
2nd Formula Field: If the term is X (only if it contains an "earlier of" term, calculate the 2nd half date for [MSO Delivery Deadline2]
3rd Formula Field: Compare [MSO Delivery Deadline1] & [MSO Delivery Deadline2], and return the earlier date.

I was just given new terms that want me to calculate the "later of" date, in the same set of formulas. Currently, my comparison only allows for the "earlier of" result, and I'm not sure how to have those new terms calculate on the "later of" result.

*My 1st formula field is over 60 lines long, or I'd paste it in here.