Automated Date Format for first Friday of the month that falls on the first full week

Question

Hello! I'm pretty sure that the 'first full week' element of this throws a spanner in the works, however, here goes... I'm trying to automate a date in Jira to add the date that is the first Friday of the month, BUT only if it falls on the first full week (so if the 1st is a Tuesday, Wednesday, Thursday or Friday, then we need the Friday of the week after)

Jason Handcock · Answer

Hi @Trudy P Claspill Thanks for coming back to me on this one.

I haven't created the rule yet as I'm a little unsure how to create it due to the complicated nature of it.

The trigger is that once one work item it marked as completed, always at the beginning of the month.

Yes, it will always be in the current month, as it is marked completed on the day it goes live.

Maybe if I attempt to explain my use case a little better...

A work item will be created to compile all information for the monthly newsletter.

On go live day, this will be marked as completed, this will always be made live on the first Friday of the first full 'working' week of the month.

If the week starts on a Saturday, Sunday or Monday this would be a full week, if it starts on any other day, the following week would be the first full week of the month.

Mikael Sandberg · Answer

To add to @Trudy P Claspill answer, when does your week starts? Does it start on Sunday or Monday? Depending on the answer you can check the date, if your week starts on Sunday, Friday date should be between 6 and 13 (5 and 12 if your week starts on Monday).

Trudy P Claspill · Answer

Hello @Jason Handcock

Welcome to the Atlassian community.

Can you provide images that show your complete rule? It will help us advise you when we understand well the rule runs.

When does the rule run relative to that Friday date you are trying to calculate?

Is it running on a scheduled triggered every Friday (or some other schedule)? Is it triggered by an event or manually?

Is the Friday you are trying to calculate always going to be in the current month relative to the execution date of the rule? The month following the execution date of the rule?

Without the full context of the rule it is challenging to offer advice that can be applied to your specific scenario.