How do you create a range for 30-59 days?

Question

Hello,

I am needing to create a filter for any tickets created between 30-59days,  60-89days, 90-119days, etc.

We have tried to create filters for tickets created 30d+, 60d+ and 90d+ but that results in many duplicates since anything in the 60d+ will also be in the 30d+ and the same thing for the 90d+.

I've been trying to use the following format below but it isn't pulling any results. Please Help!

createdDate >= startOfDay(-30d) AND createdDate <= endOfDay(-59d) AND Resolved is EMPTY

Jack Brickey · Answer

Hi @Fernandez, Katie

Can you try the following? This should yield last 30d. To prevent overlap you can omit the greater than or less then on one side of your boundaries

createdDate >= startOfDay(-60d) AND createdDate <= startOfDay(-30d)

Fernandez, Katie · Answer

Nevermind, I figured it out. Leaving this here incase anyone else finds it useful. :)

and created <= startOfDay(-30d) and created >= startOfDay(-59d)