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

Calculated (scripted) Duration Field as number of days only

I am using Calculated (scripted) Duration Field to get the resolution time between two custom dates.

For reporting purposes I however need only the number of days, e.g. 1 day or 2 days, not 1d 5h 14m - when I do charts, I need to have the number of issues that took 1, 2. 3 etc. days to resolve.

So, is there a way to return the value of Calculated (scripted) Duration Field as number of days only?

 

The script I am using:

import java.text.SimpleDateFormat;
 
Date createdDate = issue.get("customfield_13708");
if (createdDate == null)
  return null;issue.get("customfield_13708")

Date resolvedDate = issue.get("resolutiondate");
if (resolvedDate == null)
  return null;issue.get("resolutiondate")
 
SimpleDateFormat sdf = new SimpleDateFormat("d/MMM/yy");
return (resolvedDate.getTime() - createdDate.getTime())/1000L;

 

1 answer

1 accepted

1 vote
Answer accepted

If you only want a number of days, why not create a Calculated Number field instead and return a number of days instead of a number of seconds?

That worked, thanks :)

import java.text.SimpleDateFormat;

Date createdDate = issue.get("customfield_13708");
if (createdDate == null)
return null;issue.get("customfield_13708")

Date resolvedDate = issue.get("resolutiondate");
if (resolvedDate == null)
return null;issue.get("resolutiondate")

return Math.round(((resolvedDate.getTime() - createdDate.getTime())/86400000L) * 1) / 1;

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

5 mobile apps for Jira Cloud to boost productivity

  It’s very important to have access to the workflow process from anywhere. Especially if you manage the work of others. There is no difference whether you’re out of office, or drive a ca...

209 views 2 5
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