Forum Discussion

ShereeBrown's avatar
ShereeBrown
Qrew Cadet
7 years ago

How do I return the maximum date from multiple date fields but only if not greater than today?

Ultimately I want to send a reminder on the same date as a specific recurring event from a list of 15 multiple date fields.  So I am trying to create a formula field that returns the maximum date that...
Formulas and functions
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
Try this:
Max(
  If([MRI 3 Month] <= Today(), [MRI 3 Month]),
  If([MRI 6 Month] <= Today(), [MRI 6 Month]), 
  If([MRI 9 Month] <= Today(), [MRI 9 Month])
)