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

Community
Q&A
Jira
Questions
What time do the startOfWeek and endOfWeek functions start and end?

Jira Service Management to Jira Work Management

hello!

I'd love to get some feedback from anyone who may have done something similar.. currently trying to get users to submit a ticket for an event planning request, to then move it into another project for management. I found this option below, but I'm curious to see if anyone else has used it in a similar matter or if there's another option. so far it's been pretty good.

https://www.atlassian.com/software/jira/templates/event-planning

3 answers

1 accepted

6 votes

Answer accepted

Hi Jack,

startOfWeek() starts Sunday 00:00 h

endOfweek() is Saturday just before Midnight

Cheers,

Udo

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Ivaylo Dimitrov likes this

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks again Udo and thanks as well to Bharadwaj. I will pass this info onto our administrators to get it changed.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

12 votes

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.