How to calculate two date fields and show the difference in days in number?

[Fernando Passos]

Hi, 

I have two fields Date A and Date B, I would like to subtract these fields for example {Date A} - {Date B} and return the value in days or number is it possible? in the example above I use the number value and string value and the result is not as expected. I'm using the JWT CAlculated Number.

Result: Calculated Date-Time

Data A: 08/May/20

Data B: 09/May/20

Data Total: 31/12/69 21:00

Result: Calculated Number Field

Data A: 08/May/20

Data B: 30/May/20

           Data Total N : 0

[Thorsten Letschert _Decadis AG_ · Accepted solution]

Hi @Fernando Passos ,

given your two fields and assuming Date B is the larger one, the expression should look like:

round({bbbbb} - {aaaaa}) / {DAY}

Please replace aaaaa and bbbbb with the field codes for Date A and Date B.

Since you might want to ensure that the calculation will only be executed if both fields are set, I'd recommend the following expression:

{aaaaa} != null AND {bbbbb} != null ? round({bbbbb} - {aaaaa}) / {DAY} : null

Cheers
Thorsten

[Fernando Passos]

Hi @Thorsten Letschert _Decadis AG_ ,

Perfect! I had the result I expected, thank you very much.

[Fernando Passos]

I used this one. round ({Data B} - {Data A}) / {DAY}

[Abulfaz Shukurov]

Thank you very much!

[John Funk]

Hi Fernando,

I use Automation For Jira to do that. I created a number field then populate it with this:

{{issue.customfield_17152.diff(issue.customfield_16921).days}}

[Fernando Passos]

Hi John,

Thanks for the help, but we don't have automation for jira in the company, we have script runner, behavior and the JIRA workflow Toolbox. Can we achieve this result with the add-ons we have?

[John Funk]

I don't use any of those. You would need to contact their support directly. Sorry. 

[Fernanda de Souza Thaumaturgo]

@John Funk It worked perfectly, thank you very much!!

[Stephanie Loraine Garrido Brito]

Hello! @John Funk 

It seems you are using the custom fields id?

Where can I find them?

Thanks in advance

[Sebastian Krzewiński]

Hi @Fernando Passos 

Please check Adaptavist Script runner library - https://library.adaptavist.com/

There you can find helpful scripts ready to use, e.g. - https://library.adaptavist.com/entity/calculate-the-difference-between-two-dates

Regards,

Sebastian

[Fernando Passos]

Hi @Sebastian Krzewiński

Thanks, I'll check and return.