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.

  • Quickbase Alumni
  • January 11, 2019
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.