Automation - How to use variable inside Date plus function

CEDRIC DEVAUX

Hello community,

 

I need your help, I want to automatically update due date when start date is postponed.

At ticket creation, Start Date & Due Date has been completed by user. 

When user postpones start date, I want to get difference of business days between the initial start and the new value then I add this difference to the due date

ex:  Initial start Date 2024-07-16, user changes to 2024-07-17

Difference days  =>  1day

Automation rule to update Due Date +1 Business Day

I create this rule but at calculation level,:

1. I create a customfield to get intial start before changing

{{fieldChange.from}}

2. I create a variable  "businessDaysToAdd "to calculate difference between initial start date to new start date

{{issue.customfield_10044.diff(issue.customfield_10861).businessDays.abs}}

3. Update due date with calculation with Date plus function

{{DueDate.plusBusinessDays(businessDaysToAdd)}}

 

It seems that a variable inside calculation  Date.plus function is not take into account.

Here my automation rule and my calculation.

Thank you in advance for your help

Bill Sheboy

Hi @CEDRIC DEVAUX 

Created variables are text, and to use them in a function requiring a number they must be converted by adding asNumber.  For example:

{{issue.someDateField.plusDays(varSomeVariable.asNumber)}}

Here are some other recommendations for the rule you show:

• Perhaps write that created variable to the audit log to confirm it contains what you expect
• I note you are using the absolute value function after the diff on business days.  Is that because you have the dates in the reversed order? 
  • This is relevant because the person who edited the field could make the start date earlier.  And so adding the days may not produce the results you expect.

Kind regards,
Bill