Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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 write a JQL to find issues status changed between two dates which include the TIME?

This questions has been asked but the answers do not include time. The following works but we need to add the time to this jquery and it doesn't seem to work:


status changed during (2019-06-01, 2019-06-20) to (Approved)


Adding time to the date ranges results in an error.

2 answers

status changed during ('2019-06-01 10:00', '2019-06-01 12:00') to (Approved)

Hi, this works well. Thank you.

Please is there a way how to filter by person who made that change ? 
I´ve tried  "status changed BY (username)" but it will not filter that specific change but any change that was made during task life cycle.

Thank you

Does the dates mention in during refers to the updated Date on the Jira ?

I think it refers to the jira transition date, but not totally sure

This should work...

STATUS Changed AFTER '2019-06-01 10:00' BEFORE '2019-06-01 12:00' TO Approved BY username

See this doc page for details:

0 votes

If I wanted to get all Blocked tickets that are at least 3 weeks old, how does the syntax for these fields "(+/-)n(yMwdm)" end up working? Because the below doesn't.

status changed DURING (endOfWeek(), endOfWeek(-3w)) TO (Blocked)

The startOf... endOf... functions take parameters in their own units. You don't specify a unit.

In other words:

endOfWeek()  means the end of current week,

endOfWeek(-1) means the end of last week,

endOfWeek(-2) means the end of the week before the last,

... so on.

Suggest an answer

Log in or Sign up to answer

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