Filter: open bugs during the range of one month

[Brian R]

I am trying to create a filter that will pull a list of high priority bugs that were open (not done, not archived) during a specific date range (a one month period). 

So far I have tried:

project = "X" AND type = bug and priority > Medium AND status was not Done and status was not Archived AFTER '2017-03-01' BEFORE '2017-03-31'

But when I look at the results of that search, I see bugs that were created after the date range, so obviously those bugs were not open back in March 2017

Please help :)

[Kian Stack Mumo Systems]

I would try something like this: 

project = "X" AND issuetype = bug AND priority > Medium AND status was not in (Closed, Archived) during ("2017/03/01", "2017/03/31") and created <= "2017/03/31"

Notice that we are looking or tickets that didn't occupy those statuses during that time period. We also need to filter out any tickets created AFTER that which is why we only want to return tickets created at or before your date range. 

[Brian R]

That appears to work!!!