nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Heather Thomas_48eobc

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).

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.

Accepted answers

Trudy P Claspill

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}}

All comments

Trudy P Claspill

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}}

Heather Thomas_48eobc

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)

Ravina

Hi,

I have also tried this by using the Text field(single line) but it is not working.

Any suggestion.

Admin_ezx9bs

@Trudy P Claspill hello , the result gives the duration off all days and not only business days . Do you know haw to acheive the same result with only business days please ?

Trudy P Claspill

Hello @Admin

Please click the Ask button in the blue menu bar above to start your own new Question post.

1. Creating a new Question will get it better visibility in the community than adding to a post that is three years old.

2. Adding to such an old post is referred to as "necroposting" and is considered poor community etiquette.

Admin_ezx9bs

https://community.atlassian.com/t5/Jira-Service-Management/how-to-get-the-difference-between-the-created-and-resolution/qaq-p/2916795#M191667

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

automation