Custom Date Field - Coalesce two dates into a new field

[Elizabeth.Johnson]

I have some projects that are set cycles; like planned monthly or quarterly work and these projects have defined due dates. 

I have other projects that have an estimated Compl. date; where the date is more based off the estimates and other tasks, as opposed to a set schedule. 

I would like to create a new field called "Final Date" that choses the due date but if that is blank, then it would choose the estimate Compl. date.

Is that something that is available in JIRA? 

[Trudy Claspill · Accepted solution]

There are a few ways to accomplish that goal.

One is to create the custom field and set it using an Automation Rule that looks at the other two fields and determines how to set the new field.

How often would you want that check to be executed? At what point in the issue lifecycle do you require the Due Date or Estimated Completion Date field to be set?

You could trigger your automation rule based on an event, like Field Value Change or Issue Created, or you could set the rule to be triggered on a schedule if there is no hard rule about when the dates have to be filled in.

[Elizabeth.Johnson]

@Trudy Claspill

Thank you! I you gave me an idea that I can have have the an automation rule, triggered on field value change. 

If my estimated Completion Date field as a value, then it should set that as the due date. If it changes, then then due date changes. 

Then maybe I don't even need this third field. Thank you so much, I will go test this out :)