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

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