Issue about queries on created date

[Margaux Jousse]

Hello all, 

I have created a query to find all tickets created between 2 specific dates, but the result shows me some tickets that were created a few months before the dates i wanted. Could you please help me ? 

Here the query : 

"Sub Issue Type" = "Product content -Text Fix" AND labels = DTW OR labels = WEBC AND (createdDate > "2024-12-15" AND createdDate < "2025-03-31")

And in my results I Have 2 tickets from August 2024

Thanks, 

Margaux

[Atlass Monster · Accepted solution]

I think it's because the " OR " logic. 

Try like this: "Sub Issue Type" = "Product content -Text Fix" AND (labels = DTW OR labels = WEBC) AND (createdDate > "2024-12-15" AND createdDate < "2025-03-31")

You can also write the labels like this : ... AND labels in (DTW,WEBC) AND ...

[Margaux Jousse]

Hello, 

Thank you very much, it did work  !! 

Best, 

Margaux 

[Atlass Monster]

Cheers mate!