How can I use smart value dates to skip Fridays?

[Melanie Panem]

We're trying to auto-generate the due dates for our team at each step of our project processes.

However, our deploy dates can't ever be on a Friday. How would we tell the date logic to skip this day of the week?

My guess is that we'd have to use {{dayOfTheWeek}} in combination with a conditional statement in the Automation advanced field editing JSON area. Does anyone have any experience with this?

[Tim Martin · Accepted solution]

Are you also skipping the weekend?

Eg, you simply want: Due Date = next Monday-Thursday after Deploy Date

Probably a few ways to do it, but try something like this: 

Then, if true:

And if false:

[Melanie Panem]

Thanks Tim!

Your answer sent me in the right direction, and now I'm using

• if/else conditionals to compare the format("EEE") to Fri
• and then adding an extra day if it's equal
• else using the regular date calculation.

It's working beautifully! Thank you!

[Najm Polaris]

Hi @Melanie Panem

What is the current logic of assigning the deploy dates? 

[Melanie Panem]

Thanks for your question! It's pretty simple right now, we're just adding 1 regular day (as opposed to M-F business day) to the previous date field's value - at least, in most instances.

{{customfield_12432.plusDays(1).jiraDate}}

But now we need it to always skip Fridays.