How to create story on 2nd business day of month using JIRA Automation

[Kiran Punjabi]

How to create story on 2nd business day of month using JIRA Automation

[Karan Sachdev · Accepted solution]

Hey @Kiran Punjabi

Welcome to Atlassian Community.

You can create an automation rule with the Schedule trigger, using Cron expression in the Advanced scheduling:

Trigger: Schedule: Cron Expression: 0 0 9 2 * ? (This will create a work item at 9 am on the 2nd day of every month)

Action: Create Work Item

You may refer to this document for details on the cron expression: 

Construct a cron expression for a filter subscription

Thanks!

[Kiran Punjabi]

This did not help.  I am looking for story to be created on 2nd weekday of the month, i.e. 2nd business day. Thanks Karan. 

[Karan Sachdev]

I believe we don't have a way to define working days in automation schedule.

You can use basic scheduling to set it for 2nd Monday or 2nd Wednesday of each month:

However, I look forward to suggestions from other community members as well.

Thanks!

[Bill Sheboy]

Hi @Kiran Punjabi -- Welcome to the Atlassian Community!

Adding to the suggestion from @Karan Sachdev ...

• You could use a Scheduled Trigger automation rule, which runs every day,
• And add a Smart Values Condition to compare that to the second business day of the month before proceeding.  That date may be found using the date / time functions.  For example...

smart values condition

• first value: {{now.jiraDate}}
• condition: equals
• second value: {{now.firstBusinessDayOfMonth.plusBusinessDays(1).jiraDate}}

The rule will run every day, but only proceed when the date matches the condition.  And please note well: this will not detect any non-working holidays.

Kind regards,
Bill

[Kiran Punjabi]

Thanks a lot @Bill Sheboy . Your suggestion helped. The solution worked. Thank you so much.

[Bill Sheboy]

Awesome; I am glad to learn it is working!  Please consider marking this question as "answered" to help others with a similar need find solutions faster.  Thanks!

[Alexander Hohmann · Accepted solution]

Perhaps you could also something with the Smart Value "firstBusinessDayOf Month"

First business day {{[date].firstBusinessDayOfMonth}}

Returns the first business day of the month. Business days are considered to be Monday to Friday, 9am to 6pm.

{{now.firstBusinessDayOfMonth}}

See: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#First-business-day---

You will need this to calculate the difference:

Date difference {{[date1].diff([date2]).[unit]}}

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

[Kiran Punjabi]

So , what I need is that automatically on every 2nd working day ie  (2nd weekday of the month), a JIRA story to be created at 9 am.

[Alexander Hohmann]

Well, if your date difference between now amd the firstBusinessDayOfMonth is +1, then it is the second business day. So the "unit" in this case would be "businessDays". Have you tried it?

[Alexander Hohmann]

Sorry, wrong question, cannot erase.

[Alexander Hohmann]

How about comparing the current date to a fixed set of dates that you would regularly renew, e.g. yearly?