Formula to compare 6 dates and determine which was first

[Kuovonne]

Using a formula to get the earliest/latest date across several fields

Sometimes you want to know the latest date across several fields. [image] While there are many ways to do this, I present one way that works with date/time fields as well as date fields can be easily expanded to include additional date fields preserves the original time, down to the millisecond is blank when all the input date fields are blank Here is a formula to get the latest date. IF( OR( {date1}, {date2}, {date3} ), DATETIME_PARSE( MAX( IF( {date1}, VALU…