Why is this script not working

Marianne Bowen September 12, 2019

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

1 answer

1 accepted

0 votes
Answer accepted
Brittany Wispell
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 12, 2019

Hi @Marianne Bowen 

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

Hope this helps!

Marianne Bowen September 12, 2019

Thank you, it helped.

 

Have a great day

 

Marianne

Brittany Wispell
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 12, 2019

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!

Suggest an answer

Log in or Sign up to answer