Formula to show min date in DD/MM/YYYY format

[Sam_Giovenco1]

Hi There,

Seeking some help writing a formula to show the minimum of two date fields in a specified format. I have it working but showing without a forward slash.

Formula used so far is =

MIN(VALUE(DATETIME_FORMAT({6QIssuedDate},"DD/MM/YYYY")),

VALUE(DATETIME_FORMAT({6QTriggeredDate},"DD/MM/YYYY")))

This is showing as DDMMYYYY but need the format at DD/MM/YYYY

Thanks

[dilipborad · Accepted solution]

Hello @Sam_Giovenco1 

Use this one if there are maximum number of fields is only 2 fields.

IF(IS_BEFORE({Field 1}, {Field 2}), {Field 1}, {Field 2})

Then change date options respectively, if needed.

[Sam_Giovenco1]

Thanks @dilipborad that worked perfectly 👍