Hello all,
I'm looking to create a custom count on that's more than 2 weeks and less than 3 weeks on the created date. The below returns nothing, but i can see there is data, I expect it's how the created dates are.
created >= "-15d" and created <="-20d" and status in ('Waiting for Customer', 'Waiting for Support', 'Escalated')
Can someone advise?
I think you have your signs reversed due to the minus days values, so perhaps try:
created <= "-15d" and created >="-20d" and status in ('Waiting for Customer', 'Waiting for Support', 'Escalated')
For something like this it can help to draw a quick number/time-line, mark up what you want, and then select the values and signs for the expression.
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.