difference of Creation date and resolution date of tickets in Jira

[Nirmal Kumat]

i am using below in the jira automation to get the difference in days for creation date and resolved date.

{{issue.resolved.diff(issue.created).days}}

[Mayur Jadhav]

Hi @Nirmal Kumat ,

Welcome to the Atlassian Community,

I think it will work you need to create new text field to hold the difference value.

I found the similar thread and it is answer by @John Funk

Regards,
Mayur

[Nirmal Kumat]

ok thanks Mayur for confirming. yes i am holiding the value in some new text field.. just wanted to make sure that it would work.

[Nirmal Kumat]

@Mayur  - any idea if and how we can accomplish the difference of creation and resolution date by using a Jquery ?

[George Elshamaa]

Hey @Nirmal Kumat ,

Have you considered using Jira's native "Resolution Time Report". This calculates it in the same way as it checks the difference between an issue's Resolution Date and Created date. It also provides you with trends in the average time taken to resolve issues.

I hope this helps and let me know if you have any questions.

Thanks,

George 

[Nirmal Kumat]

how do i access resolution time report ?

[George Elshamaa]

If you navigate to your project and click on "Reports" on the sidebar, you'll find the "Resolution Time Report" under "Issue Analysis"

[Nirmal Kumat]

will this work ?