How to calculate the number of days a ticket is over the due date?

[Breonna Bowen]

We are currently trying to capture the number of days a ticket is overdue, based on the difference between the due date and now. 

I keep getting the following error message: 

Could not convert the field value to a number. Please ensure the value is a number, math expression or smart-value that can be converted into a number. Total Time Overdue in Days: {now.diff(issue.duedate).days}}

Can someone tell what smart value I should be entering to make this work? 

[Mohamed Benziane · Accepted solution]

Hello @Breonna Bowen 

Welcome to the community.

Not an automation expert, but can you try this:

{{now.diff(issue.dueDate).days}} instead of {now.diff(issue.duedate).days}}

https://support.atlassian.com/jira-software-cloud/docs/use-smart-values-to-manipulate-and-format-dates/#calculating-the-difference-between-two-dates 

[Breonna Bowen]

Ah! Thank you! 

[John Funk · Accepted solution]

Hi Breonna - Welcome to the Atlassian Community!

You are missing a { at the very beginning of the Smart Value. It should have two {{

[Breonna Bowen]

That worked, thanks! 

[Zaldy Parian]

Hi @John Funk 

I tried this: {{now.diff(issue.created).days}} on my automation. But it returned an error of:

Error while parsing additional fields. Not valid JSON.
Any idea why?

We're using Jira Cloud. And I'm trying to update a custom field when the status is changed.

Regards,
Zaldy

[John Funk]

Hi Zaldy - can you share the rule that you have? 

[Zaldy Parian]

Hi @John Funk ,

I think I got it now.

And I have to move now() after issue.date to get a positive number.

Thanks for your help.