Skip to main content

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

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.

Thanks @dilipborad that worked perfectly 👍

Reply


Terms & Conditions