How to calculate the difference between date of creation and date of resolved in jira cloud

[Pantham Akhil]

Hello all how to calculate the difference between the created date and resolved date in jira cloud using automation rule can you guys please help me in this..

Thanks

[John Funk · Accepted solution]

Hi Pantham,

Create a custom number field to hold the value of the difference.

Then add a new action for Edit issue and select the new field. 

You can put this in the field: {{issue.resolved.diff(created).days}}

[Jack Brickey]

Hi @Pantham Akhil ,

have you reviewed this doc - jira-smart-values-date-and-time 

please share the automation that you currently have and where it might be stuck.

[Hannes Obweger - JXL for Jira]

Hi @Pantham Akhil

I know you're explicitly referring to Automation for Jira - but depending on your use case, you may not even automation to get to this value. For example, we just introduced "Time between created and resolved" as a special field in JXL for Jira. You can add it to your issue table like any other field, sort and filter by it, and export it to Excel, all without any kind of automation or scripting involved.

This is how it looks in action:

(Disclaimer: I work on JXL :))

Hope this helps,

Hannes