# formula to determine the max of multiple date values

Topic Labels: Dates & Timezones Formulas
Solved
653 3
cancel
Showing results for
Did you mean:
6 - Interface Innovator

I have a formula that works as is today, but I'm trying to add a condition to it and it keeps erroring out?  Was hoping to get some extra eyes on it?

What we're doing today is taking 3 different date fields, convert them to a #, and then display the max of the 3 fields.  This might be a weird way to get where we need to go, but it has worked for us.  All the "correct" fields are date fields in our base.

Formula today:

IF(
OR({Correct Lift + 45}, {Correct Clamp + 45}, {Correct Date Mod}),
DATETIME_PARSE(
MAX(
IF({Correct Lift + 45}, VALUE(DATETIME_FORMAT({Correct Lift + 45}, 'YYYYMMDD'))),
IF({Correct Clamp + 45}, VALUE(DATETIME_FORMAT({Correct Clamp + 45}, 'YYYYMMDD'))),
IF({Correct Date Mod}, VALUE(DATETIME_FORMAT({Correct Date Mod}, 'YYYYMMDD')))
),
'YYYYMMDD'
)
)

So what I'm wanting to do is add a 4th date into the equations, so wouldn't my new formula be:

IF(
OR({Correct Lift + 45}, {Correct Clamp + 45}, {Correct Date Mod},{New Value}),
DATETIME_PARSE(
MAX(
IF({Correct Lift + 45}, VALUE(DATETIME_FORMAT({Correct Lift + 45}, 'YYYYMMDD'))),
IF({Correct Clamp + 45}, VALUE(DATETIME_FORMAT({Correct Clamp + 45}, 'YYYYMMDD'))),
IF({Correct Date Mod}, VALUE(DATETIME_FORMAT({Correct Date Mod}, 'YYYYMMDD'))),
IF({New Value}, VALUE(DATETIME_FORMAT({New Value)},'YYYYMMDD')))
),
'YYYYMMDD'
)
)

But I'm getting an error?

1 Solution

Accepted Solutions
11 - Venus

Looks like there's an extra ")" in there.
{New Value)} -> {New Value}

``IF({New Value}, VALUE(DATETIME_FORMAT({New Value},'YYYYMMDD')))``

3 Replies 3
11 - Venus

Looks like there's an extra ")" in there.
{New Value)} -> {New Value}

``IF({New Value}, VALUE(DATETIME_FORMAT({New Value},'YYYYMMDD')))``

5 - Automation Enthusiast

Where are you writing this syntax in airtable. I am not able to do such type of things @Sho

6 - Interface Innovator

Thank you!