Can you set an automation rule to update "Due Date" with latest date 3+ fields from same issue?

JD MG

I'm struggling to write a rule that compares multiple date fields and uses the latest one to update the value of the Due Date field, could you please advise?

i.e. 

Custom Field Date 1 (equals 1/1/25)

 

Custom Field Date 2 (equals 2/2/25)

 

Custom Field Date 3 (equals 3/3/25)

 

Custom Field Date 4 (equals 4/4/25)

Due Date = latest date between Custom Field Date 1 - 4 (value should be 4/4/25)

 

Bill Sheboy

Hi @JD MG -- Welcome to the Atlassian Community!

There are several ways to do what you asked; let's try a simple one using a dynamically created list of dates with a variable and the inline max function:

• action: create variable
  • name: varDateList
  • value:

{{issue.customFieldDate1}},{{issue.customFieldDate2}},{{issue.customFieldDate3}},{{issue.customFieldDate4}}

• action: something that needs the maximum date by converting into a list with split() and converting back into dates

{{varDateList.split(",").toDate.max}}

 

Some other ways to do this are:

• a bunch of conditional expressions or if / else blocks (...quite messy)
• convert the dates into date / times, convert those into epoch times, use the long-format max() function over all of them, and then try to convert the result back into a date / time
• etc.

 

Kind regards,
Bill