automation for date difference

[Ivan Andrieiev]

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 @Ivan Andrieiev 

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

Thanks,

Manisha

[Ivan Andrieiev]

@Manisha in other project I have 0 in result.

[Jamie]

Thanks for the info.

Instead of the difference between 2 dates I needed to calculate the duration of the difference in days. 

For example, if today is the start date and tomorrow is the end date, the difference calculated (using the logic in this post) is 1. But the duration is 2 days (going off the basis of start of day/end of day).

To get this logic working I used the following

{{#=}}{{issue.customfield_XXXX.diff(issue.duedate).days}} + 1{{/}}

Which seems to work a treat.

[John Funk]

Hi @Ivan Andrieiev 

Can you share a screenshot of the audit log? 

[Ivan Andrieiev]

@John Funk  Hi

[John Funk]

What type of field is Feedback? Number? Text?

[Ivan Andrieiev]

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. 

[Ivan Andrieiev]

@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. 

[Ivan Andrieiev]

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}}

[Ivan Andrieiev]

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. 

[Ivan Andrieiev]

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.  :-)

[Ivan Andrieiev]

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

[John Funk]

Great!