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
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))
You can just run this,
duedate < 183d AND "Start date" < 213d
kindly accept the answer if this resolve the issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Something like this...
”start date” <startofday(“+180”)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.