JQL Query - between two dates

[Deleted user]

I'm looking to write a script that shows me all the 'issues' where the date field is 7 days before today and 7 days after today.

I have the two below scripts, but I need one that integrates both of them;

Everything 7 days from today

"Start Date" <= endOfDay(7d) and "Start Date" >= startOfDay()

Everything 7 days before today

"Start Date" >= startOfDay(-7d)

[JamieA · Accepted solution]

Don't you just want to OR the two clauses together, ie

("Start Date"<= endOfDay(7d) and"Start Date">= startOfDay()) OR
"Change Start">= startOfDay(-7d)

[Deleted user]

Although, changing your script slightly seems to work

"Start Date" <= endOfDay(7d) AND "Start Date" >= startOfDay() OR "Start Date" >= startOfDay(-7d) AND "Start Date" <= startOfDay()

[Deleted user]

Unfortunaly not as the first one will give me all the issues 7 days from today and then EVERYTHING before today, and then the second one gives me all the issues from 7 days before today and then EVERYTHING after today. So putting them both together basically gives me EVERYTHING :(

[Anila]

created > startOfDay(-7) AND created < startOfDay(-6)