date query

[Julie Sgroi]

I'm trying to create a query for all work items created and Completed/Closed in 2020.  With Advanced Search, I can find all issues created in 2020, but can't then filter for Done in 2020.

[Bill Sheboy · Accepted solution]

Hi @Julie Sgroi 

You could try this one to see if it helps:

project = myProject
 AND created >= "2020-01-01"
 AND created <= "2020-12-31"
 AND statusCategory = "Done"
 AND statusCategoryChangedDate >= "2020-01-01"
 AND statusCategoryChangedDate <= "2020-12-31"
 ORDER BY Key

Best regards,
Bill