Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

"Due in a week' and "overdue" filters don't show what's due today

Steven Kent
Contributor
October 25, 2021

Hi

I use this in a filter to find issues with a Due date in the next week

due <= 1w AND due > now()

and I use this in another filter to show issues where the due date has passed

duedate < now()

It appears though that neither filter show issues due today. If today = the entire day I think I can see why that logically occurs, but can anyone advise how to avoid this i.e. have issues due today either in 'due in 1 week' or 'overdue'?

1 answer

1 accepted

1 vote
Answer accepted
Steven Kent
Contributor
October 25, 2021

Stop looking :)

I added OR duedate = now() to the "due in one week" filter. Oh the shame... :)

John Funk
Community Champion
October 26, 2021

Glad you figured it out. Always fun to see your own mistakes after publishing to the world.  :-)

Suggest an answer

Log in or Sign up to answer