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

Scriptrunner - Find the time difference between 2 date / time fields

Brooke Anglin

I have the following scripted field. It is returning a value but it isn't the correct value. See code below and example.

import com.atlassian.jira.component.ComponentAccessor;

import com.atlassian.jira.issue.Issue;

import java.util.Date.*

def customFieldManager = ComponentAccessor.getCustomFieldManager();

def dateFieldObject= customFieldManager.getCustomFieldObjectByName('Restored Date/Time');

def dateFieldObject2= customFieldManager.getCustomFieldObjectByName('Incident Start Date/Time');

if(issue.getCustomFieldValue(dateFieldObject) && issue.getCustomFieldValue(dateFieldObject2))

{

def dateValue= issue.getCustomFieldValue(dateFieldObject) as Date

def dateValue2= issue.getCustomFieldValue(dateFieldObject2) as Date

return dateValue.getTime() - dateValue2.getTime()

}

EXAMPLE FROM TOOL: ((note MTRS is my scripted field))

Incident Start Date/Time: 2019-01-25 1:51

Restored Date/Time: 2019-01-25 04:52

MTRS: 17 weeks, 6 days, 16 hours, 40 minutes

The correct duration is 3 hours, 1 minute

Can anyone help me with this please ????

Accepted answers

All comments

Nic Brough -Adaptavist-

Have a look at the raw number that your subtraction gives you - your scripted field is converting it to text based on the wrong unit of measure.

Tarun Sapra

Hello @Brooke Anglin

Possible duplicate

https://community.atlassian.com/t5/Jira-questions/ScriptRunner-find-number-of-days-between-two-custom-date-fields/qaq-p/596551

You can add some logging and then see the unit of time returned and then you can convert it to the unit you want and return it as "double"

Brooke Anglin

the raw number also doesn't make any sense either. Another example is the duration is 20 min but the number template displays 1,200,000 and the duration template displays 1 week, 6 days, 21 hours, 20 minutes

How can the unit measure be corrected?

Tarun Sapra

Hello @Brooke Anglin

It's correct

the number displayed is in milliSecond.

Brooke Anglin

WHY DID I NOT THINK OF THAT ?????? I was able to divide by 1000 and it gave me the correct duration

THANK YOU THANK YOU THANK YOU

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server