Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I list the difference between the created date and resolution date as days, hours, minutes?

I am creating automation in Jira (cloud) on a company-managed software to find the time to resolution.  I need to list in a field on the issue how long it takes for the issue to go from created to resolved.  The result needs to be listed in Days, Hours, Minutes. 

Here is what I have tried (I can get a total number of hours or a total number of days but not a combination of the 3 that I need).

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

I have tried using the following custom field types: Text Field (single line), Date Time Picker, Number Field. 

I read something about prettyPrint will display the difference in words but I can't get it to work. 

1 answer

1 accepted

0 votes
Answer accepted

Hello @Heather Thomas 

Welcome to the community.

What have you tried for prettyPrint? From what I've read (I haven't actually tested this), the following should work

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

Thank you. That did work. I was making the mistake of using hours, days, etc with the prettyPrint.  Also, it worked for the custom field type: Text Field (single line)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

517 views 19 25
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you