nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL Query - between two dates

unknown

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" &lt;= endOfDay(7d) and "Start Date" &gt;= startOfDay()

Everything 7 days before today

"Start Date" &gt;= startOfDay(-7d)

Accepted answers

JamieA

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

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

All comments

JamieA

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

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

unknown

Although, changing your script slightly seems to work

"Start Date" &lt;= endOfDay(7d) AND "Start Date" &gt;= startOfDay() OR "Start Date" &gt;= startOfDay(-7d) AND "Start Date" &lt;= startOfDay()

unknown

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 Albert

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

jqlquerybuilder