Can you create a filter by calendar week

Question

Hello,

I'm somewhat new to Jira and have looked on the Advanced Searching page but didn't find what I was look for so I figured I'd start here next.

Is there a way to create a JQL filter based on calendar week and not specifically by number of days or weeks?  For example, we frequently review tasks daily based on calendar week due date and I have created a Kanban board with swimlanes that are segregated by calendar week. I've created manually filters for the next three weeks but have to keep changing the filter every week.

Week 10: duedate >= "2021/03/08" and duedate <="2021/03/12"

I know that I could use duedate > 7d but that doesn't quite work if we check, for example, on Friday vs. a Monday.

Thanks for any assitance,

Tim

unknown · Accepted Answer

I found another way around it, which was to use startofweek() and add days, such as:

duedate >= startOfWeek() and duedate < startofweek("+7d")

This ensures that no mater which week day we discuss the content, I can keep filters such as "Current Week", "Next Week", "Third Week" and the dates automatically roll.