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
So, I have over 60 different terms listed in a field. These are the examples of the 3 types of terms (single, earlier of, later of)

180 days from end of FW
earlier of 6 mos end of FW / 9 mos from beginning of FW
later of 6 mos end of FW / 24 mos from 1st pymt

I have a case statement formula calculating the single & 1st date ([MSO Delivery Deadline1]), and another one to calculate the 2nd date ([MSO Delivery Deadline2]).

Then I have a 3rd formula to compare the 2, returning the earlier of the dates.

Min ([MSO Delivery Deadline1], [MSO Delivery Deadline2])

My problem is that they just gave me new terms that are "the later of" now. Not sure how to calculate both in the same formula.