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

[Mathew Lederman · Accepted solution]

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.