How to setup automation for date picker 5 business days before last Business day of the month?

[admin-nwalter]

Hello all,

I am trying to setup an automation for a date picker. The situation is as follows:

For each ticket made in our project, a custom date picker is set to the last business day of that month (we'll call that field Customdate A for now). There is also a start date that I want to setup 5 business days BEFORE the Customdate A field. So something in the lines of:

{{now.lastBusinessDayOfMonth}} minus 5 business days.

My goal is then to setup the automation that whenever the value changes for Customdate A, the start date gets automatically populated based on the above values. Is this possible to setup? I haven't found anything on the official articles yet that could do something like this. 

[Alexey Matveev]

Your JQL would look like this

status changed to Open after -1d or status changed to Closed after -1d

[Derek Pence]

What if I'm looking to find those that were closed within one day for the last month or quarter etc... And thank you for your time.

[Alexey Matveev]

Ah, I see. There is no built-in function like this In ScriptRunner. You could write our own JQL function with Power Scripts or ScriptRunner add-on.