Date Calculations - Syntax

Question

Hi everyone,

Hopefully an easy one here.  I want be able to calculate, in Jira Automation, the duration (in business days) between two dates.

I've used:

Duration would = {{issue.Start date.diff(issue.duedate.plusDays(1)).businessDays}}d

This works great if that start and due dates are more than a day apart, but not if they are the same date, it returns null.

I think I may have the wrong syntax/position for the .plusDays(1).

Any help greatly appreciated.

Cheers,
JonC

Evgenii · Answer

Try this. Checked it, it's working. First variant was completely wrong.

{{#if (equals(issue.Start date.jiraDate, issue.duedate.jiraDate))}}
0d
{{/}}
{{#if (not(equals(issue.Start date.jiraDate, issue.duedate.jiraDate)))}}
{{issue.Start date.diff(issue.duedate.plusDays(1)).businessDays}}d
{{/}}

Jonathan Cunliffe · Answer

Hi @Evgenii

Thanks for the speedy response.  I must be missing something here as I'm not getting anything back from the formula.

I've enter it as:

But get back:

Am I missing something here?

Thanks again.

Evgenii · Answer

Hi, @Jonathan Cunliffe

After some examination of documentation, looks like you need to experiment with if conditions, they can help in your case.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

Take a look at isEquals() method.