How to calculate the difference between issue created and resolved

Ada Dedja January 25, 2022

Hello, 

I am trying to create an automation in Jira, where I store the time that was needed for the issue to be resolved when we have an outage, referred as "Down Time". I tried {{issue.resolved.diff(issue.created).hours}} and {{issue.created.diff(issue.resolved).hours}} but the result didn't make any sense. 
Is there a way I can obtain this result? I checked the math expressions, but no result. Thank you!
automation.pngresult.png 


1 answer

1 accepted

5 votes
Answer accepted
Pramodh M
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 25, 2022

Hi @Ada Dedja 

Can you use the below Smart value and let me know if this is convenient

{{issue.created.diff(issue.resolutiondate).prettyPrint}}

Ref here

https://community.atlassian.com/t5/Jira-Software-questions/How-can-I-list-the-difference-between-the-created-date-and/qaq-p/1874959

Thanks,
Pramodh

Ada Dedja January 25, 2022

Hi @Pramodh M 

Thank you for your help!

The Down Time is type "Date and Time Picker" it still shows a weird date, but I created another custom field "Short text type" and it worked.

Regards, 
Ada

Like Pramodh M likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events