nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What JQL query can give me current week as Monday to Sunday, which works even on Sundays?

Lucky Uche

I have a simple query which shows me all issues resolved in the current week starting from Monday:

resolved > startOfWeek(1d)

This query works perfectly on every day of the week until we get to Sunday, which should be the last day of the week and should display everything resolved since the week started on Monday. Unfortunately, Sunday is fixed as the start of the week for Jira and it's not possible to change it (company-managed account, etc).

Question is: is there any possible JQL query that could give me results with Monday to Sunday as the week, no matter what day of the week I'm checking it?

Accepted answers

All comments

Jack Brickey

Have you considered enabling ISO8061 calendar? This is a global setting so be sure this is desirable across the board. changing the setting does require system admin permissions.

Pramodh M

Hi @Lucky Uche

This JQL will give issue result from Monday to Sunday for the current week (no matter what day of the week you're checking it)

resolved >= startOfWeek("+1d") AND resolved <= endOfWeek("+1d")

This JQL will give issue result from Monday to Sunday for the previous week (no matter what day of the week you're checking it)

resolved >= startOfWeek("-6d") AND resolved <= endOfWeek("-6d")

Let me know if you need any clarification.

1 2 3 4 5 6 7 8 9 0

Thanks,
Pramodh

Pramodh M

Good one @Jack Brickey Thanks

Lucky Uche

Hello @Pramodh M thanks for the response. Unfortunately, the JQL doesn't work on Sunday. It works fine from Monday to Saturday but on Sunday, like today, it doesn't.

Here's why: it considers today as "startOfWeek", so it would be looking for issues resolved from "startOfWeek("+1d")" which is tomorrow. I want it to show me issues resolved from Monday 17th to Today 23rd.

Lucky Uche

I'm not sure of the details but I've raised the concern to the company system admin before and it can't be changed. This was the response I received:

This cannot be changed globally in Jira Cloud and is a known issue / limitation from Atlassian: https://jira.atlassian.com/browse/JRACLOUD-71611

That's why I'm seeking a JQL query that works even on Sunday. I want to believe the one I have is not the best possible.

Pramodh M

Hi @Lucky Uche

the JQL doesn't work on Sunday. It works fine from Monday to Saturday but on Sunday, like today, it doesn't.

The above statement is wrong. JQL searches for issues even on Sundays for startOfWeek function, infact startOfWeek() search starts on Sunday

Here's the Proof

Reference here

So when you search for issues, it should return the issues resolved as per your requirement!!

resolved >= startOfWeek("+1d") AND resolved <= endOfWeek("+1d")

+1d refers to Monday for startOfWeek and Sunday for endOfWeek in the above JQL

Go ahead and try it and see the result

Let me know if you have any queries

Thanks,
Pramodh

Lucky Uche

Hello @Pramodh M

I understand the JQL you sent but I don't think you understand the request I'm making, so let me try to elaborate.

In my company, today Sunday 23rd is the last day of the week, so I want a JQL that will give me issues resolved between Monday 17th and Sunday 23rd. The JQL you sent sees Sunday as start of the week and Monday as "start of the week +1d". This means that if I run this JQL today being Sunday, it will search for issues resolved between Monday 24th (which start of the week +1d) and Sunday 30th (which is end of the week +1d).

The difference is simply that while I am still in the week of 17th to 23rd, Jira is already in the week of 23rd to 29th. So startOfWeek("+1d") for Jira means Monday 24th and not Monday 17th which is what I actually want.

I hope this is clear.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

jql

atl-orange