Difference between two dates are showing in the Negative and in the form of Seconds

[Ashok32]

Hi All,

While we are calculating the difference betrween two date Field values. I ts showing the difference in the form of seconds and negative values are generating at the time of report generation. In the list level, Its showing as

Whereas in report level the difference shows like

-86817

Can anyone help me to resolve this.

Thanks in advance

[Ankur Bawiskar]

@Ashok32 

can you share what script are you using for calculating?

[Ashok32]

 var start = new GlideDateTime();
var end = new GlideDateTime(current.end_date);
var dur = new GlideDuration();
dur = GlideDateTime.subtract(start, end).toString();
current.setValue('u_diff', dur);

[Ankur Bawiskar]

@Ashok32 

script looks good.

[Ashok32]

Hi @Ankur Bawiskar ,

In the reports its shows duration in seconds and that too its a negative value. How can we convert that seconds to  minutes or days in the report level.