How to write a JQL to find issues status changed between two dates which include the TIME?

[Scarlet Fitness]

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.

[Ilya Turov]

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

[Jindřich Löffler]

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

[NIKHIL KUMAR]

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

[Emily Ewart]

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

[Emre Toptancı _OBSS_]

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:

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-operators-reference-939938745.html#Advancedsearchingoperatorsreference-CHANGEDCHANGED

[Emily Ewart]

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)

[Emre Toptancı _OBSS_]

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.