Between 2 dates dynamically

Lewis Flisher_fhkv8g

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?

Bill Sheboy

Hi @Lewis Flisher 

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