Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

Deleted user Sep 19, 2013

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

3 answers

1 accepted

5 votes
Answer accepted

Hi Jack,

startOfWeek() starts Sunday 00:00 h

endOfweek() is Saturday just before Midnight

Cheers,

Udo

Deleted user Sep 25, 2013

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.

Like Ivaylo Dimitrov likes this
Deleted user Sep 25, 2013

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

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

This was incredibly helpful, thanks!

Like Marvin Cabreros likes this

Thanks Rebecca. That was brilliant

Deleted user Feb 18, 2019

Thanks Rebecca!

Like Marvin Cabreros likes this

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.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you