I'm trying to create a filter to find tickets that have less than a certain number of days before the due date. This is what I have been trying:
Project = "project name" AND created >= -14d AND "Due date" < 3d order by created DESC
I adjust the filter due date value in bold and no tickets appear, even though I can clearly see tickets in the project that would meet the criteria. Also, there are a mix of tickets that have both due dates set with a value and set to Null, but when I run this filter, no tickets show up:
Project = "project name" AND "Due date" !=Null ORDER BY created DESC
However, if I change it to the following, there are tickets that show up:
Project = "project name" AND "Due date" = Null ORDER BY created DESC
What am I doing wrong?
