Find the closest date out of 2 other columns

[wonka1234]

Hi,

Say I have [column1] with a date value of 2023-07-11 and

[column2] with a value of 2023-07-31 

and [column 3] with a value of 2023-08-30

how can I find the column closed to column 1 in a formula? the answer would be column 2 in this instance.

[FrederikE]

Hey @wonka1234,

IF
DateTimeDiff([Field1],[Field2],'days')
>
DateTimeDiff([Field1],[Field3],'days')
THEN "Field2"
ELSE "Field3"
ENDIF