Skip to main content
Question

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

  • January 11, 2019
  • 0 replies
  • 83 views

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" function in another formula. Now I have two new terms that are based on the "the later of" two dates, so the "Min" function won't work anymore.

Looking for suggestions.


Example of the comparison formula:
Min ([MSO Delivery Deadline1], [MSO Delivery Deadline2])

This topic has been closed for replies.

Max() is the function you need.

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.