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?

Arkadiusz Zychewicz Jun 12, 2014

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

0 votes
Jobin Kuruvilla [Go2Group] Community Leader Jun 12, 2014

How about this:

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

Jobin Kuruvilla [Go2Group] Community Leader Jun 12, 2014

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

Arkadiusz Zychewicz Jun 12, 2014

So how to get which week is now?

Jobin Kuruvilla [Go2Group] Community Leader Jun 12, 2014

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

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

Arkadiusz Zychewicz Jun 12, 2014

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
This widget could not be displayed.
This widget could not be displayed.
Community showcase

Friday Fun: What's your best vacation planning hack?

Let's face it, work can be challenging but fulfilling, especially when you enjoy the challenges thrown at you.  However for me, nothing compares to going on vacation (or holiday as some of you m...

582 views 29 4
Join discussion

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