Why is this script not working

[Marianne Bowen]

I am trying to see every ticket that was closed during a particular timeframe. This is the query I am using, and it returns tickets that are way outside the range. How can I fix this? 

project = TOM AND type in (story, bug) AND status not in (Open, Testing, Analysis) AND resolved > 2019-05-31 AND resolved < 2019-07-01 ORDER BY resolved ASC

[Brittany Wispell · Accepted solution]

Hi @Marianne Bowen 

Try replacing with resolved >= 2019-05-31 AND resolved <= 2019-07-01

Hope this helps!

[Marianne Bowen]

Thank you, it helped.

Have a great day

Marianne

[Brittany Wispell]

Awesome to hear it! 

Can you please mark this as an accepted answer so it can help the rest of the community if they run into the same issue :) 

Thank you!