Earliest Formula Between Three Dates
Formula 1: Days Since First {Date}
Review:
TODAY()-Date = The Number of Days between that date and Today
TODAY()-10/10/2020 = 990
Requirement -
I want to find the earliest formula between three different date fields
Simple solution for Formula beginners, Write Two Formulas
Formula #1:
Type: Number
Use Max function to compare the three date fields.
This field determines the number of days between all the dates and determines which is the largest.
Date1 = 10/27/2022
Date 2 = 04/29/2021
Date 3 = 11/13/2021
Looking at this you easily see this on that April 29, 2021 is earliest.
What the formula is doing is looking at these numbers and determining which number is the largest:
Today()-10/27/2021 = 608 days
Today()-11/13/2021 = 591 days
Today()-04/29/2021 = 789 days
We are telling Salesforce to fill in the number that is largest of the three equations above and to only evaluate the date field if it is not blank.
Formula #2:
Type: Date
Earliest Date between 3 dates
If you want to know what date that was 30 days ago, you can subtract 30 from Today and get a date field.
Today()-30 =05/28/2023
CASE can be a multiple “If” formula
CASE(TODAY() - DaysSinceFirstDate, Date1 , Date1, Date2 , Date2, Date 3, Date 3, NULL)
Determines which Date field is First when subtracted from today, by matching Days Since First Date Formula.
