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
Nevermind, I figured it out. Leaving this here incase anyone else finds it useful. :)
and created <= startOfDay(-30d) and created >= startOfDay(-59d)
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.