Looking for rolling JQL that will define the next Tuesday or actual day as due date

[Aimee Heigold]

I am trying to write a JQL code for a filter that will show what's due in a specific review for every upcoming Tuesday and a separate one for the upcoming Friday. Here are some examples of what works:

"Review[Date]" = endOfWeek("-1d") /
"Review[Date]" >= startOfWeek("-1d") AND "CR1 Date[Date]" < endOfWeek("-3d")

My issue is that the function only works about half of the days, so I end up with multiple versions depending on the day viewed. 

Any advice to get cleaner more consistent results? Thanks

[Walter Buggenhout]

Hi @Aimee Heigold,

What is the problem you are trying to solve here? It looks as if you are trying to fetch a list of items to discuss in a review meeting, but with a hard dependency on a date field. 

Starting from that idea, your examples are pretty much ok. But have you considered solving your process differently? If you need to review stuff, why don't you use a workflow status to identify the issues that need review? Or a custom field / label / ... to identify the issues that need to be reviewed

I am aware that I don't know your full use case here, but just suggesting that there may be easier, more flexible ways to solve your problem than filtering out issues with a dynamic date on a certain day of the week.

Hope this helps!