JQL issue for last 7 days

Hoc_qsdf87

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_yd9k36

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.