Can MIN() compare date fields in Salesforce?

Not directly. MIN(StartDate, CustomerSignedDate) fails with "Incorrect parameter type, Expected Number, received Date". Subtract a fixed date from each field, take MIN of those numbers and add the result back to the fixed date.

How do I find the earliest of three dates in a formula?

Use DATE(1900,1,1) + MIN(Date1 - DATE(1900,1,1), Date2 - DATE(1900,1,1), Date3 - DATE(1900,1,1)) with a Date return type. In my test it returned the earliest of three contract dates.

Why does my MIN() date formula return blank?

If any date is blank, the result is blank. Wrap each date in BLANKVALUE with a far-future date, such as BLANKVALUE(StartDate, DATE(4000,12,31)), so blank dates are skipped.

How do I get the minimum value across related records?

MIN() works on one record only. Use a roll-up summary field with the MIN type on a master-detail relationship, a Flow-based roll-up for lookups, or the MIN() aggregate in SOQL.

What is the difference between MIN and MAX in Salesforce?

MIN returns the smallest value and MAX the largest. Combine them to keep a value in a range, for example MAX(0, MIN(Score__c, 100)).

MIN() Function in Salesforce | Syntax, Examples, & Use Cases

The MIN() function in Salesforce returns the smallest of two or more numbers: MIN(Discount__c, 0.25) caps a discount at 25%. It only accepts numbers, so MIN(StartDate, CustomerSignedDate) fails, but you can still find the earliest of several dates with a simple workaround that I tested below.

In this tutorial, you’ll find the syntax, practical number examples, the tested date formulas (including how to skip blank dates), and when a roll-up summary or MAX() is the better tool. Everything was checked in a Salesforce Developer Edition org.

This Tutorial Covers: