Calculate day difference correctly

Roman Wolf

Hello everyone,

I am using JIRA Cloud and it's Automation feature. I am stucked at a minor issue someone might have a solution for:

Goal: Calculate day difference from today til a day in future

Formula: now.diff(version.releaseDate).days

The formula works and returns a value. But the result is not correct from a human point of view.

 

Assume this formula is called during Friday and releaseDate is the upcoming Monday the result of the formula is: 2

As a human I would expect: 3 and interpret 2 as Sunday.

I understand why the formula returns 2. But is there a way to achieve a result of 3?

I didn't found anything about rounding ...

 

Thanks, Roman

Roman Wolf

Thanks to @Tony Langlet I found the solution to my problem.

Root cause: The release date comes only with a date value and a zero timestamp (as there is no timestamp to configure).

The value of NOW comes with a date and a timestamp value (non-zero).

Diff both values result in a floating number which than gets converted into an integer . The internal rounding renders the result to be wrong.

Solution: One way to solve this is give the NOW value also a zero timestamp. Then the diff calculation will work out as expected.

Calling 

now.toStartOfDay

does the magic.

 

Full function:

now.toStartOfDay.diff(version.releaseDate).days

 

Regards, Roman