How can I calculate between two dates(resolved date and create date) in JQL ?

[Orkun Ovayurt]

How can I calculate between two dates(resolved date and create date) ?

How many days and hours between these days ? Can you help me ?

[Marc - Devoteam]

Hi @Orkun Ovayurt 

Welcome to the community.

You can use smart values for this.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/ 

You can store this in a custom field ot type text

{{[date1].diff([date2]).prettyPrint}}

[YY Brother]

Hi @Orkun Ovayurt 

Welcome to our community.

Solution A:

1.Create a custom field called Lead Time

2.Create an automation rule to calculate the lead time when jira work items are resolved

now() - issue.created = lead time

In the Edit Issue action, set the lead time to above calc value

Solution B:

Some apps maybe.

Hope it helps,

Thanks,

YY Brother

[Birkan Yildiz _OBSS_]

Selamlar @Orkun Ovayurt Bey,

If you are open to using a marketplace app, Timepiece - Time in Status for Jira is what you are asking for.
Its Duration Between Statuses report is designed to do exactly what you need. You can simply select the first status (e.g., To Do) as your start point and last status (e.g., Resolved) as your end point, and the report will calculate the total duration for each issue.

This gives you your "Resolution Time" or "Lead Time" without needing any complex workarounds. Also, you can see the total time in minutes, hours, days, weeks, etc.


You can check Timepiece - Time in Status for Jira on the Atlassian Marketplace. Hope this helps you get the data you're looking for! Please feel free to reach out if you have further questions.

Disclosure: I'm on the team that makes Timepiece - Time in Status for Jira.