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

[Aaron Corbin]

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, 

[Mark Segall · Accepted solution]

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)}}

[Aaron Corbin]

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]

You would only enter the second variable...

{{varSecondBusinessDay}}

[Aaron Corbin]

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

[Aaron Corbin]

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

{{varFirstBusinessDay.plusBusinessDays(1)}}

or this:

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

[Mark Segall]

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