Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1308 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam_Giovenco1
5 - Automation Enthusiast
5 - Automation Enthusiast

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
1 Solution

Accepted Solutions
dilipborad
9 - Sun
9 - Sun

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.

See Solution in Thread

2 Replies 2
dilipborad
9 - Sun
9 - Sun

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
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks @dilipborad that worked perfectly 👍