Quick Filter Query - Hide issue that are in the future (more thn 6 Month)

[Gaetan Gaston]

Hi folks,

I'm have a team that has repetitive task and in order to plan, we will create issue from now to end of 2022 (it is controle and process check). Therefore in our Jira, we want to implement a code that said : Exclude issue that are in the future (more than 6 month)

MY WISH: I want to :

-> Exclude issue that START DATE is more than 26 weeks or 182 days

-> Exclude issue that DUE DATE is more than 26+4 weeks or 212 days

CODE FAIL :(

NOT ("Start Date" < 183d OR duedate < 213d)

What would be the rignt code ?

Thanks

[Gaetan Gaston · Accepted solution]

It is always complicated with negative query (like "Exclude"), even more if it is crossed by another multiple-date query (older than "Start-date" and older than "Due-Date") 

Here is the best I have found :

("Start Date" = empty AND duedate = empty) OR ("Start Date" = empty AND (duedate < 213d)) OR (("Start Date" < 183d) OR duedate = empty) OR (("Start Date" < 183d) AND (duedate < 213d))

[Sandesh Shetty]

@Gaetan Gaston 

You can just run this,

duedate  < 183d  AND "Start date" < 213d

kindly accept the answer if this resolve the issue

[Jack Brickey]

Something like this...

”start date” <startofday(“+180”)