Can a JIRA query be written to retrieve issues contained in Sprints closed within a date range?

[Lawrence Krebs]

I am trying to retrieve issues (stories, subtasks) that were contained in Sprints that were closed between 2020-01-14 (Jan 14th 2020) and 2020-11-23 (Nov 23rd 2020).  I don't see a field such as Sprint Closed Date available.

If it did exist, I could add a clause like this:

AND SprintClosedDate between 2020-01-14 and 2020-11-23

Can a JIRA query to do something like that?

[Jack Brickey]

you should be able to just simply use sprint not in opensprints() and resolutiondate between the dates that you want

[Lawrence Krebs]

Follow-ups question:  What is the date format? CCYY-MM-DD?

In other words, would it look like this?

Sprint not in openSprints() AND (resolutiondate >= 2020-01-14 AND resolutiondate <= 2020-11-23)

[Lawrence Krebs]

Actually I think that is it... Thanks for the help?

[Lawrence Krebs]

help! (that is)

[Jack Brickey]

Sprint not in openSprints() and (resolutiondate >= 2020-01-14 AND resolutiondate <= 2020-11-23)