Days Overdue Calculated Field Not Taking into Account Year

Rebecca Hagerty

Hello,

I am trying to create a calculated field that shows the number of days a task is overdue.

My current automation is:

{{now.diff(issue.dueDate).days.abs}}

However, the problem is it isn't calculating properly. I have one due date that was in 2023, but it's calculating everything as if it was this year. How can I fix this?

Trudy P Claspill

Hello @Rebecca Hagerty 

Welcome to the Atlassian community.

Can you show us your entire automation rule, please? Sometimes the results are unexpected due to the context in which a given step is executing.

Have you tried adding Log actions to your rule to print the {{issue.dueDate}} value into your rule execution Audit Log, to confirm the field has the value you think it should have?

What is an example of a dueDate used in this calculation and the result of the calculation that you think is incorrect?