I want to get the issues whos status changed from In Progress to Closed between the particular date

[Adriano Rocha]

I want to get the issues whos status changed from "In Progress" to "Closed" between the particular date for creating a report.

[Sagar Mahajan · Accepted solution]

@Adriano Rocha You can use the below JQL query to get the issues which changed the status from between the 1st Jan 2023 to 20th Jan 2023

project = "your project name" AND status changed FROM "In Progress" to "closed" during (2023-01-01,2023-01-20)

[Adriano Rocha]

Thanks @Sagar Mahajan 

[Trudy Claspill · Accepted solution]

Hello @Adriano Rocha 

Welcome to the Atlassian community.

You can use the CHANGED operator for that.

status CHANGED FROM "In Progress" TO "Closed" DURING ("date1","date2")