How to export issues with resolution "Done" and "Closed" from last year

[Soraia Luís]

Hello There,

I'm triyng to export issues from last year with the resolution "Done" and "Closed" but my JQL is returning issues from this year to.

project in (XPTO,XPTI) AND issuetype in (Bug, RAD) AND status in (Closed, Done) AND resolutiondate >= 2023-01-01 AND resolutiondate <= 2023-12-31 ORDER BY updated DESC, created ASC, summary ASC

Could you help me?

Thanks

[Laurie Sciutti]

Hi @Soraia Luís ~ you can also try:  

resolved >= startOfYear(-1) AND resolved < startOfYear()

[Sunny Ape]

Trying using resolved instead of resolutiondate.

Also, unless you have other statuses other than Done or Closed for resolved issues, then adding the "status in (Done, Closed)" to the JQL is duplication, since finding issues with resolved dates is the same thing.