How can I filter all tasks where the status changed to Done within the last two weeks?

[Astrid Skillingstad]

I would like a filter that shows me all tasks that are open AND where the status has changed to Done within the last 2 weeks. Older tasks should not appear. 

[John Funk · Accepted solution]

Hi Astrid,

Try this:

project = ABC and status changed to Done after startOfDay(-14)

Or you can use startOfWeek(-2)

[Astrid Skillingstad]

It seems like that only gives me the tasks where the status has changed within 2 weeks. Is there a way to get BOTH open tasks AND marked as done within 2 weeks in the same filter?

[John Funk]

So sorry - I missed the part about wanting open tasks, too.

project = ABC and (status changed to Done after startOfDay(-14) or statusCategory != Done)

[Astrid Skillingstad]

I believe that solved my problems! Thanks a lot for your help and fast reply.

[John Funk]

Great! Glad I could help.