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

[Arkadiusz Zychewicz]

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?

[Jobin Kuruvilla [Go2Group]]

How about this:

resolutiondate >= startOfWeek(-12) AND resolutiondate < endOfWeek(-12)

[Jobin Kuruvilla [Go2Group]]

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

[Arkadiusz Zychewicz]

So how to get which week is now?

[Jobin Kuruvilla [Go2Group]]

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]

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