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

Aimee Heigold March 4, 2024

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

1 answer

0 votes
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 5, 2024

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!

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events