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
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.
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.