Automation - How to edit jira issue with the duration of the ticket based on Due date - Start date

Vanessa Formigoni

I want to create a Jira automation to get a customized field automatically filled after I include the Start date and Due date. The customized field is Duration and I want to know how many days it took to have the ticket completed.

 

This is the format of the Start and Due date "MMM DD, YYYY" or Jan 18, 2024 for example.

 

I tried to use this 

{{#issue.duedate}}{{#issue['Start date[Date]']}}{{issue.duedate.diff(issue['Start date[Date]'], 'days')}}d{{/}}{{/}}

and other formulas and had no luck. I am always getting 2,020 as a result. 

Bill Sheboy

Hi @Vanessa Formigoni 

Looking at that expression, it is unclear to me in what format you want to set the value for the diff: a number, text, etc.

The diff value itself would be:

{{issue.Start date.diff(issue.duedate).days}}

Please adjust if the smart values in your Jira site are different.

Kind regards,
Bill