How can I automate setting a date field in a subtask based on a date field in a story?

Question

I have an automation rule set up that when a custom field (date field) in the story is updated, it updates the date to a different field in the subtask.

I would like the date in the subtask to be minus 7 Business Days from the date in the custom field, but am not able to figure out the JQL.

Any suggestions?

Akhand Pratap Singh_z78moi · Answer

Hello @Naomi Mack ,

In your Automation Rule, where you will be editing Date field value for Subtask set that as

Here ABCDE is your Custom field ID.

Bill Sheboy · Answer

Hi @Naomi Mack -- Welcome to the Atlassian Community!

If I understand your question, the rule would not use JQL to do that.  Instead it would use the minusBusinessDays() function:

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

If that does not help, please post images of your complete rule, the Edit Issue action where the change is made, and the audit log details showing the rule execution.  Those will provide context for the community to offer better suggestions.

Kind regards,
Bill