automation for date difference

[Іван Андрєєв]

I have an automation to calculate the difference between Due date and Start date, the audit shows that it works, but the Feedback is not filled. What could be the problem?

[Manisha · Accepted solution]

Hi @Іван Андрєєв 

As per the screenshot, both start date and due date are same 24Apr 2023. This could be the reason.

Thanks,

Manisha

[Іван Андрєєв]

@Manisha in other project I have 0 in result.

[John Funk]

Hi @Іван Андрєєв 

Can you share a screenshot of the audit log? 

[Іван Андрєєв]

@John Funk  Hi

[John Funk]

What type of field is Feedback? Number? Text?

[Іван Андрєєв]

Text Field (single line)

[John Funk]

use {{issue.Due date.diff(issue.Start date).days}}

Smart values are case sensitive and the field name has to be exactly the same. 

[Іван Андрєєв]

@John Funk 

there are problems with the calculation, the field is not filled

[John Funk]

So you copied my code above and it still does not update the field? 

If so, sub out now() for one of the dates and see if that works. 

[Іван Андрєєв]

two different field formats, changed different dates, but even so it turns out that the audit log says "success", but the field is not filled, maybe the problem is in the format of the fields where the dates are placed?

[John Funk]

My apologies for not being clearer. I meant try this:

 {{now.diff(issue.Start date).days}} and see if it populates anything. Or

 {{now.diff(issue.Due date).days}}

[Іван Андрєєв]

sorry for my misunderstanding, it turns out that the rule did not work with the "Due date" option, what is the problem then?

[John Funk]

Atlassian's example uses {{issue.duedate.

Try that format again with the now option and see if that works. 

And if so, try to string them together again. 

[Іван Андрєєв]

that's how it works, thank you very much.
{{issue.Start date.diff(issue.duedate).days}} - with this expression, it outputs non-negative numbers, if on the contrary, it counts minus, for example -2. Shouldn't it be the other way around?

[John Funk]

Not if your Start date was two days before your Due date. Which I would hope it is.  :-)

[Іван Андрєєв]

understood, thanks for your help, the issue is resolved.

[John Funk]

Great!