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?