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

How to find all issues which was resolved in some week of year?

I want to make a query which return to me all isssues resolved in specifed week of year. For example I want to know howm many issues was reslolved in 12 week of 2014 year.

So I need something like this:

firstDayOfWeek(12) <= resolutiondate AND resolutiondate < lastDayOfWeek(12)

is there any?

1 answer

How about this:

resolutiondate &gt;= startOfWeek(-12) AND resolutiondate &lt; endOfWeek(-12)

This is relative to current date. i.e. 12 weeks before. But you can adjust the number as appropriate.

So how to get which week is now?

Current week is 0. -12 will be 12 weeks before now.

Btw, you can use the absolute dates if you already know it.

This is in fackt my problem how to make query not relative to current date. And meke relative to absolute week number.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in United States

Live! - Austin ACE -- Summer BASH 2019

Hey Austin! Come join us for our 2019 Atlassian Community Summer BASH as we transition ourselves into party status! Bring an attachment, log a great time, and collaborate with new friends as we celeb...

9 views 0 0
View post

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