How to query on issues that had a specific status on a certain day

[Mukesh Panchal]

Hello,

Im trying to query issues having specific status as of a certain day e.g. I would like to know how many issues were fixed yesterday by checking issues transitioned from status A to status B, yesterday. I'm using following query:

issuetype = Bug AND status changed FROM "In Development" to "DEV COMPLETE" and (updatedDate < -1d AND updatedDate > -2d)

But this query shows me all the issues that were updated yesterday which once had a status of "In Development". I need to know issues that were changed from status of "In Development" to "DEV COMPLETE", yesterday. The issues may be in a different status now.

Any help is appreciated.

[Daniel Deng · Accepted solution]

Try this one

(status changed FROM "In Development" TO "DEV COMPLETE" AFTER endOfDay(-2)) and (status changed FROM "In Development" TO "DEV COMPLETE" BEFORE  endOfDay(-1))

[Mukesh Panchal]

Thank you. It worked.