MAX_DATE_ELEMENTS() : find the latest date (among linked dates)

In a formula column, the MAX_DATE_ELEMENTS() function returns the most recent date across several date columns, including columns holding several dates such as Column from a linked table fields. The result is a date.

Syntax

MAX_DATE_ELEMENTS(column1, column2, column3)

Parameters

# Parameter Description

1 column1, column2... A column holding one or several dates. Can be a Link to another table column or a Column from a linked table returning dates.

Examples

Find the most recent date across three columns

The column returns the most recent date among the linked dates.

MAX_DATE_ELEMENTS($Dates1, $Dates2, $Dates3)

MAX_DATE_ELEMENTS applied to three Date columns

The MAX_DATE_ELEMENTS formula was applied to the three Date columns to get the most recent date among the three.

Your formula returns 0 or stays empty

None of the columns contains a date

If every column passed as a parameter is empty or holds no date, the function has nothing to compare.

The column output format is not Date

In the Options tab, set the output format to Date. For details, see Output format options in the Formula column article.

Go further

MIN_DATE_ELEMENTS

The opposite operation: get the earliest date from the same set.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.