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 · Accepted solution]

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

[JD MG]

Interesting, i think this could work, will this be OK if any of the customFieldDates is blank?

[Bill Sheboy]

Yes, it will work if one (or more) of the date fields is empty (i.e., null).  If all of the date values are null values, the result will be null also.

[Akhand Pratap Singh · Accepted solution]

Hello @JD MG ,

You can also use If and else condition in Automation for Jira, basically 3 if and else condition.

For Consideration: Field IDs for mentioned Custom fields are:

Custom Field Date 1 = 10111

Custom Field Date 2 10112

Custom Field Date 3 10113

Custom Field Date 4 10114

Action: Field value changes for anyone of the mentioned 3 fields.

Condition: 

• If: 
  {{issue.customfield_10111.compareTo(issue.customfield_10112)}} < 0 and {{issue.customfield_10111.compareTo(issue.customfield_10113)}} < 0
  and {{issue.customfield_10111.compareTo(issue.customfield_10114)}} < 0
  Action: Edit issue Duedate and copy value of Custom Field Date 1
  
  
• Else: {{issue.customfield_10112.compareTo(issue.customfield_10111)}} < 0 and {{issue.customfield_10112.compareTo(issue.customfield_10113)}} < 0
  and {{issue.customfield_10111.compareTo(issue.customfield_10114)}} < 0
  Action: Edit issue Duedate and copy value of Custom Field Date 2

Similarly, you can add other else for remaining 2 date fields

@Bill Sheboy correctly mentioned it to be quite messy, as it will take you to create quite a few if and else blocks