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; } } }

Rolling 2-4 month date range

Keith Shipman

Hi I'm trying to create a filter using JQL that will show me any issues with an Actual Change Start Date of between 2 and 4 months of today's date, has anybody got any suggestions or advice?

Essentially I'm trying to create a report that will show me issues that have been in a column for more that 2 months but less than 4.

Hope that makes sense and thanks in advance

Accepted answers

Mathew Lederman

created >= startOfDay(-4M) and created <= startOfDay(-2M) ORDER BY created DESC

Swap out 'created' for whatever date field you like.

All comments

Mathew Lederman

created >= startOfDay(-4M) and created <= startOfDay(-2M) ORDER BY created DESC

Swap out 'created' for whatever date field you like.

Keith Shipman

Brilliant thanks Mathew! Still very early in my JQL learning so really appreciate this

Mathew Lederman

@Keith Shipman if this answers your question, please be sure to click 'Accept answer' so other users can find the best answers to historical questions.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud