I need to display the difference between two dates as number of years. How to do this using JWT?

[Gunasekaran N]

I would like to use this in the post function of my service desk workflow, to update a numeric field based on the two mandatory date fields that have value. Start date and End date are available. The requirement is to populate the numeric field - "Duration in years"

[Gunasekaran N · Accepted solution]

Hi @Thorsten Letschert _Decadis AG_ ,

I used the following formula based on your suggestion. It worked as expected. Thank you!

round(({00012}-{11604})/{YEAR})

[Gunasekaran N]

{00012} is the system date-field "Due Date" and {11604} is a custom date-field "Start Date"

[Thorsten Letschert _Decadis AG_]

Hi @Gunasekaran N ,

Assuming that you want to calculate the date difference between those two fields in years, you can try an expression like

({issue.cfEEEEE} - {issue.cfSSSSS}) / {YEAR}

where EEEEEE is the ID of your End date and SSSSS is the ID of your Start date. Add those two using the field picker, and make sure you're using the numeric value without the '%'.

Cheers,
Thorsten

[Gunasekaran N]

This was giving syntax error!

The post function that I am using is:

Update parameters of the Mathematical or date-time expression calculator Function for this transition.

However your reply gave me a clue. Thank you

[Thorsten Letschert _Decadis AG_]

Hi @Gunasekaran N ,

Thanks for your feedback. Could you please accept my answer then?

Cheers,
Thorsten