Due date quick filter Kanban board

Question

Hi

Our issues require us to put due dates in. I would like to add 4 quick filters based on due dates: This week, Next week, In Two weeks, Next month.

I have tried many things, but I cannot get the exact filter I want. What I need is basically filters based on work weeks Monday-Friday.

I currently have this filter for 'Due date this week': duedate <= startOfWeek(5d) AND duedate > startOfWeek(). This works, but the other filters I am having problems with.

Say it is monday today. There is an issue X with a due date set to next week Friday. I need to be able to see this issue X when I click the quick filter 'next week'.  I am not seeing something simple?

Kind regards and thanks in advance
Enis Günsüren

Rachel Margaret · Answer

This works for me

next week: duedate >= endOfWeek(1) and duedate <= endofweek(1)

Egunsuren · Answer

Hey thanks for the reply!

This week works, but next week does not. Could you elaborate on your thought process? I don't quiet understand how endOfWeek() works.

Jack Brickey · Answer

haven't proofed but try this as a starter. tweak as necessary... this week: duedate >= startOfWeek() and duedate <= endOfWeek() next week: duedate >= endOfWeek(2) and duedate <= endofweek(7)