Set Automation Due Date for the following month (1st Business Day of the Month)

[darren.johnson]

I am trying to create a due date of the 1st Business day of the month.  But, if it is already past the first business day of the month, it needs to be the first business day of the following month.

When I do {{now.firstBusinessDayOfMonth}} it puts in the first business day of the current month, even when it is past that day (therefore being overdue)

Is there a way to make this work please ?

[Martin Bayer [MoroSystems, s.r.o.] · Accepted solution]

Hi @darren.johnson , Welcome on the community.

I just played with it a little and I think you can use If/Else to handle these two situations. Give it a try and let me know if it works, please :)

[Bill Sheboy]

Hi @darren.johnson -- Welcome to the Atlassian Community!

Yes, and...to what @Martin Bayer [MoroSystems, s.r.o.] suggests:

What do you want the result to be when {{now}} is currently the first business day of the month: use "today" or use "next month's first business day"?

Kind regards,
Bill

[darren.johnson]

Hiya,
@Martin Bayer [MoroSystems, s.r.o.] @Bill Sheboy 
Little confused here, I am looking for the result to be that when I move the task to completed it re-creates it for next months first business day, so for example I have a task for 1st October that when I move it to completed it auto recreates and changes the due date to 1st November both days are business working days and so on etc...

I have tried above formula and it does not work and has broken adding the epic and moving into planned.

[darren.johnson]

@Bill Sheboy @Martin Bayer [MoroSystems, s.r.o.] 

Figured it out using {{duedate.plusMonths(1).firstBusinessDayOfMonth}}

Thank you for your help

[Martin Bayer [MoroSystems, s.r.o.]]

Hi @darren.johnson my example was not complete for your use case. I only wanted to show you how to use IF/ELSE and how to use Date smart values. In my opinion you need it because your implementation will cause

• today's date is 1st October (Saturday)
• user completes an issue and new issue should be created
• due date for the new issue should be 3rd October (Monday)
• your implementation will set 1st november which is wrong if I understand your initial question correctly :)