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 time do the startOfWeek and endOfWeek functions start and end?

Hi,

I have setup a JQL to bring me back a count of issues that were in "On Hold" during the course of last week. Query is as such:

project= XXX AND issueType = project AND status was in ("On Hold") DURING (startOfWeek(-1w), endOfWeek(-1w))

This currently returns 8 issues when I am expecting 9. On investigation i discovered the the one issue that was not counted was updated on sunday evening at about 10pm.

Question: What time does startOfWeek() start and endOfWeek() end? Does it run from Monday 00:00 to sunday 23:59?

Note: Our JIRA locale is set to GMT +2. We are in South Africa.

Hope you clever buggers can help.

Thanks

Accepted answers

Hi Jack,

startOfWeek() starts Sunday 00:00 h

endOfweek() is Saturday just before Midnight

Cheers,

Udo

All comments

Hi Jack,

startOfWeek() starts Sunday 00:00 h

endOfweek() is Saturday just before Midnight

Cheers,

Udo

Thanks for the feedback Udo. Is this configurable that the start of the week can be set to Monday 00:00 and end of the week be Sunday midnight? This would make it easier for us.

You're welcome, Jack. Please see this answer.

https://answers.atlassian.com/questions/115094/how-do-i-set-the-first-day-of-week-so-that-startofweek-returns-monday-instead-of-sunday

Bharadwaj Jannu

you read from

https://answers.atlassian.com/questions/115094/how-do-i-set-the-first-day-of-week-so-that-startofweek-returns-monday-instead-of-sunday

and may you find solution.

and try if you interest to set propeties

https://confluence.atlassian.com/display/JIRA/Setting+Properties+and+Options+on+Startup

but keep a copy of original setenv.bat

Rebecca B. Weiss

This is an easy one, no need for admin. If you want the current week to be Mon-Sun, use "startOfWeek(1d), endOfWeek(1d)". If you want the previous week to be Mon-Sun, use "(startOfWeek(-6d), endOfWeek(-6d))", and so on. smile

Kristina Kemmer_x8xl2n

This was incredibly helpful, thanks!

Marvin Cabreros

Thanks Rebecca. That was brilliant

Thanks Rebecca!

Sean Young_st31ot

When would you use startOfWeek(1w)?

I had a query that set 1w and setting 1d (monday) does the same thing. Now I'm confused.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql