JQL logic to check for created > 7d

[HH]

Hi, 

I want to check whether a ticket has been waiting for the customer for more than 7 days. I've got the following JQL, which I thought was checking whether it had been updated in anything more than or equal to 7 days, however it's returning a ticket that was created today!

(project in (10300)) AND ((Updated >= -7d AND status = "Waiting for Customer"))

So I tried to alter it to include a creation date: 

(project in (10300)) AND ((created > -7d AND Updated >= -7d AND status = "Waiting for Customer"))

However neither of these are working. Hoping someone can see where I'm going wrong! 

[Tuncay Senturk _Snapbytes_ · Accepted solution]

Hello Hollie,

If you use updated >= -7d it returns issues that are updated within last seven days. 

So, you should use <=

[HH]

Thanks! JQL blindness had set in - this was driving me mad!

[Tuncay Senturk _Snapbytes_]

Yeah, it happens sometimes and it may take hours to rescue from that blindness.