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