Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Date Field - Coalesce two dates into a new field

Elizabeth.Johnson
Contributor
October 3, 2022

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? 

1 answer

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Champion
October 3, 2022

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
Contributor
October 3, 2022

@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 :)

Like John Funk likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events