It's not the same without you

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

Sign up for free Log in

Atlassian Community Hero Image Collage

Community

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

0 votes

How about this:

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

So how to get which week is now?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS