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

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 ...