Date difference in working days

[Rakesh Pradhan]

Hi All 

I have created an automation which calculates the difference in days  between the baseline Date and Due Date when a project milestone due date is moved.  

i have used the following inthe automation step

{{issue.Due date.diff(Baseline End Date).days}}

This outputs into a custom field with a number - however this only calculate the total days difference not the working days 

Can anyone tell me how to create or amend the automation script to calculate as working days ?

regards

Rakesh

[Jack Brickey · Accepted solution]

Hi @Rakesh Pradhan , you should qualify by using "businessdays". Here is an excerpt from the documentation...

Date difference {{[date1].diff([date2]).[unit]}}

Returns the amount of time between date1 and date2, in the unit specified. If date2 is earlier than date1, the value returned will be negative.

The units that can be used with this smart value are:

• millis

• seconds

• minutes

• hours

• days

• weeks

• months

• years

• businessDays

You can also change the format of the output using the following:

• prettyPrint - displays the difference in words, e.g.: 2 days 3 hours.

• abs - returns the value as a positive number.

[Rakesh Pradhan]

thanks !!! Worked