calculated number field - negative values

Tal Kdoshim

Hi everyone,

I used the following formula:

@Formula:

if (issue.get("customfield_10411")==null || issue.get("customfield_10710") == null) return null;

return (issue.get("customfield_10411").getTime() - issue.get("customfield_10710").getTime())/1000/60;

-->

 

To get a calculated number field with the result of:

customfield_10411 - customfield_10710

 

both fields above are date fields.

 

The problem

I got a negative number (-652) for the following values:

customfield_10411= 11/Nov/18 12:34 PM

customfield_10710= 11/Nov/18 11:25 PM

 

Thanks in advance,

Tal

Nic Brough -Adaptavist-

The number looks wrong to me, as the 11 hour 49 minute difference is 709 minutes, but the negative sign is right - you're taking a larger number away from a smaller one.