JQL to get the next Monday and Monday after that

Question

Hey there,

Per the subject, I am trying to come up with a filter for our onboarding staff members.

Basically it is 'Next Weeks New Starters'

It would be >= Next Monday and < Following Monday after (next monday +7d)

I have no idea if you can build stored expressions in JSM for JQL or if I can pick dates like this or in any sort of fashion to get a specific Monday to Monday view.

Thanks.

Steven Lees-Smith · Answer

Thanks I actually sorted it out by putting the date in a startofWeek and endOfWeek bracket so I have a check that now catches the next Monday to the following Sunday to catch the range.

Gaurav_0av1h6 · Answer

Hello @Steven Lees-Smith

For this purpose, please use the in-built function startofweek(). This is assuming that the week is set to start on Monday, in the Jira instance.

An indicative usage is  shown below:

"Planned start[Time stamp]" >= startOfWeek(1)

This provides all issues that have the planned start in the next week. This can be customised as per your requirements.

Kindly accept the answer if this helps.

Regards,

GG