Help

Consider 3-4 different date values, show the latest

Topic Labels: Formulas
Solved
Jump to Solution
5682 12
cancel
Showing results for 
Search instead for 
Did you mean: 
esu
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone, I need to have a “Filter” column that is pulling date values from 3-4 different columns and selecting the one that is the most recent. So if we have 3/10/2021, 3/10/2022 and 3/10/2023, the date that populates the “Filter” column is 3/10/2023. It’s not always consistent which column will have the most updated date.

Is that possible to write a formula for?

Update:
MAX () doesn’t seem to work for anything other than Number fields.
Desired outcome is to look at multiple Date column values, pull latest date value or if all the values are the same, output the same value.
image

12 Replies 12

So, @esu, combining @Kamille_Parks’ and @kuovonne’s contributions above, this is what your resulting formula would look like.

As Kuovonne mentioned above, this would allow you to use times in your date fields as well, but would work equally fine with just dates alone:

IF(
   OR({Date 1}, {Date 2}, {Date 3}), 
   DATETIME_PARSE(
      MAX(
         IF({Date 1}, VALUE(DATETIME_FORMAT({Date 1}, 'x'))), 
         IF({Date 2}, VALUE(DATETIME_FORMAT({Date 2}, 'x'))), 
         IF({Date 3}, VALUE(DATETIME_FORMAT({Date 3}, 'x')))
      ), 
      'YYYYMMDD'
   )
)
esu
5 - Automation Enthusiast
5 - Automation Enthusiast

ahhh thank you so much @Kamille_Parks @kuovonne @ScottWorld !!

Can't get MAX() to Format the result as a DATE, only various number formats.
I am trying to pull the latest date from a single field, and display it in another field within the same table.