Show any items that are of a particular value after a specific date or if the date is null

[ksteever]

Hello!

I'm working on a Gantt chart for our leadership team of projects that are in progress. For the example sake, the table has 5 columns (Name, Start Date, End Date, Status, Updated). I want to filter out issues that have a end date of more than 14 days ago.  Something to note here is that the "end date" field will be empty until the status is moved to "done".  Is there a way to do this without doing a new column and calculating End date-Today then filtering out anything with a value of <-14?

Any help is appreciated!

[lbendlin · Accepted solution]

TODAY() - COALESCE([End Date],TODAY()) >14