I need to create an automation that compare 4 date picker custom fields and put the value in other

Sofia Grunspan

I need to create an automation rule that allows me compare four date picker custom fields and put the furthest one in a custom field of the same type named "Final Date".

The problem I've found is one of those fields to be compared can be empty.

Do you have any idea how can I structure this?

 

I have 4 data fields which I need to compare properly whenever the value of one of them changes and then select the furthest date of all and put value of it into "Final Date" field. Unfortunately if one of them has the value ‘empty’ the automaton doesn't know how to treat it so I have to add also a validation that checks if the field is empty.To do this, I need to create something like this (Example for fieldA):
----------------------------------------------------
If FieldB is empty
Or
IF FieldA is after(further) Field BAndIf FieldC is empty
Or
IF FieldA is after(further) Field CAndIf FieldD is empty
Or
IF FieldA is after(further) Field DThen put value from fieldA into "Final Date"

Bill Sheboy

Hi @Sofia Grunspan 

Do you only need the maximum value or do you need to know the specific field?  If you only need the maximum value...

One way to do this is to combine the date values to form a list, and then find the maximum value.  For example:

• action: create variable (This will create a comma-separated values list of the dates.)
  • name: varDateList
  • smart value:

{{issue.FieldA.jiraDate}},{{issue.FieldB.jiraDate}},{{issue.FieldC.jiraDate}},{{issue.FieldD.jiraDate}}

• action: edit issue, to set Final Date to this value, which splits the values, converts them back to dates, and then finds the maximum value.

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

 

This will handle if zero or more of the dates are empty, but it will not handle if all of the dates are empty.  What do you want to do in that case?

 

Kind regards,
Bill