Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,296,116
Community Members
 
Community Events
165
Community Groups

Due Date in Automation - Second, third or fourth business day of following month

Hi All. 

 

I was able to create an automation to create a task with a due date of the first day of the following month using the following formula in the due date field: {{now.plusMonths(1).firstBusinessDayOfMonth}}

 

However, I need to do the same thing but to create a due date for the second, third and fourth business day of the following month. 

 

I tried this, but it gave me an error: {{now.plusMonths(1).secondBusinessDayOfMonth}}

 

Anyone know how to get this done?

 

Thanks, 

1 answer

1 accepted

0 votes
Answer accepted
Mark Segall Community Leader Jun 16, 2022

Hi @Aaron Corbin and welcome to the community!

There are only two options for ...BusinessDayOfMonth - first or last.  So you'll need to perform an additional calculation against it.  I haven't verified myself, but you could try this:

{{now.plusMonths(1).firstBusinessDayOfMonth.plusBusinessDays(1)}}

If that doesn't work, you could try capturing the first business day as a variable and then the second business day as a variable off of that.  Something like this:

varFirstBusinessDay: {{now.plusMonths(1).firstBusinessDayOfMonth}}

varSecondBusinessDay: {{varFirstBusinessDay.plusBusinessDays(1)}}

Thanks for the quick response. I will try this out! 

 

For the second option, how would you enter the two variables into the due date field?

Mark Segall Community Leader Jun 16, 2022

You would only enter the second variable...

{{varSecondBusinessDay}}

Like Aaron Corbin likes this

Ok I just tried the first option and it works! Thanks so much. 

Like Mark Segall likes this

Just to clarify, for the second option, would you enter this: 

{{varFirstBusinessDay.plusBusinessDays(1)}}

or this:

{{{{now.plusMonths(1).firstBusinessDayOfMonth}}.plusBusinessDays(1)}}
Mark Segall Community Leader Jun 16, 2022

Yes - That makes sense for the second option.  Eliminates the need for the second variable.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
Community showcase
Published in Jira Work Management

Join us for a live demo of Jira Work Management

Interested in learning more about Jira Work Management? Have questions you want to get answered? Join us for our upcoming live demo where we’ll take you through the essentials of Jira Work Manageme...

1,674 views 4 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you