Filter that returns issues that are unresolved >= 7 days past due date

[Pete P]

I need a Filter that returns issues that are still unresolved >= 7 days past due date.  Any suggestions on syntax?  I have tried Now(+7) which was not successful.  I see other functions such as endOfWeek()  but that doesn't really help me.  We want to give users a bit of leeway in resolving issues but if they are lagging behind 7 days I have a dashboard set up I hope to surface those who exceed the period.

[John M Funk · Accepted solution]

Hi Pete,

Try Project = ABC and duedate <= startOfDay(-7) and statusCategory != Done

[Pete P]

@John M Funk that worked perfectly, ty 👌

[John M Funk]

Great!