Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Naomi Mack
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 28, 2025

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?

2 answers

3 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 28, 2025

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

2 votes
Akhand Pratap Singh
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 28, 2025

Hello @Naomi Mack ,

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

{{issue.parent.customfield_ABCDE.minusBusinessDays(7)}}

Here ABCDE is your Custom field ID.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events