What time do the startOfWeek and endOfWeek functions start and end?

[Deleted user]

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

[Udo Brand · Accepted solution]

Hi Jack,

startOfWeek() starts Sunday 00:00 h

endOfweek() is Saturday just before Midnight

Cheers,

Udo

[Deleted user]

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.

[Udo Brand]

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

[Deleted user]

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

[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. 

[Kristina Kemmer]

This was incredibly helpful, thanks!

[Marvin Cabreros]

Thanks Rebecca. That was brilliant

[Deleted user]

Thanks Rebecca!

[Sean Young]

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.