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?
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}}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Breonna - Welcome to the Atlassian Community!
You are missing a { at the very beginning of the Smart Value. It should have two {{
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Zaldy - can you share the rule that you have?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.