JQL issue for last 7 days

[Hoc]

Hello, 

I have this JQL that should be showing a 'Date' field from the last 7 days. But it is showing 7 days in the past and 7 days in the future.

From the picture below it should only show from 18/9/20 and any issue from the last 7 days not 7 days into the future as well.

This is the JQL

"Date of Last Day[Date]" >= -7d AND issuetype = "Request - Exit User" ORDER BY cf[10083] ASC

Not sure why?

[Sramanth Pandeti · Accepted solution]

Hi @Hoc Plase try the below JQL query:

"date of last day[Date]" >= "-7d" AND "date of last day[Date]" <= now()

 This query will not show any issues in the future.

[Hoc]

Hi @Sramanth Pandeti

Thanks for that. My colleague managed to show me what to do which returns the same result as what you showed. Thank you :)

Hopefully this solution helps others well

[Sramanth Pandeti]

@Hoc I'm glad this query worked :)