Skip to main content
Solved

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

  • December 4, 2023
  • 2 replies
  • 54 views
S
Forum|alt.badge.img+2

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

Best answer by dilipborad

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.

1 Attachments

2 replies

dilipborad
Forum|alt.badge.img+23
  • dilipborad
  • Brainy
  • Answer
  • December 4, 2023

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.

S
Forum|alt.badge.img+2
  • Sam_Giovenco1
  • Author
  • Participating Frequently
  • December 4, 2023

Thanks @dilipborad that worked perfectly 👍

Terms & ConditionsAccessibility statement