Running a scheduled event with JQL to test if due date is 18 Business Days away

[Alexandra Peia]

Hello,

I am trying to create a daily scheduled rule to check for issues that have the due date exactly 18 business days from today. 

I am trying: 

duedate = now.plusBusinessDays(18)

duedate.jqlDateTime = now.plusBusinessDays(18).jqlDateTime

the error is: "Unable to find JQL function 'now.minusBusinessDays(18)'." or others.

I also tries putiing the second part in {{ }} Nothing works. Thank you!

[Trudy Claspill]

Hello @Alexandra Peia 

plusBusinessDays() is not a function that can be used in a JQL statement directly. You can use it as part of a smart value to calculate a date that will be substituted into the JQL in the Automation Rule. 

Put curly braces around it thus:

duedate = {{now.plusBusinessDays(18)}}

You said you tried curly braces but you didn't show us exactly how you used them.

If my suggestion doesn't work, can you share with us screen images that show your entire Automation Rule, the details of the step that includes the JQL, and the details from the rule audit log for running the rule after that change is made?

[Alexandra Peia]

Thank you for your answer. Now I have issues with posting a reply here. Seems the due date format inludes a "+0000" at the end and this is fiddling with the rule...not sure how to change that.

[Trudy Claspill]

Can you provide more information about what you mean by "fiddling"?

If the rule is not doing what you want and you need more help then please:

1. Provide screen images showing your rule, and the details of any step that you think is not working correctly.

2. Provide screen images showing the output in the Audit Log for the rule execution. Make sure you expand all the sections of the execution log entry to reveal all the details.

3. Provide an explanation of what you want to happen versus what you are observing is happening.