Query to list all pending tasks from last two weeks

[azeem-SC]

Thanks a lot for the awesome plugin. I use it everyday.
I am trying to query the tasks that have slipped the due date with in the last two weeks.

I tried
' tasks not done
' due before in two weeks

This was not working and could not find a way to query tasks which got slipped in last two weeks.

Kindly request for some help here, thanks

[claremacrae]

Hi @azeem-SC I did a bit of experimenting and came up with this - the magic phrase is due after 15 days ago.

With this query:

```tasks
not done
due after 15 days ago
due before today
# or could use instead 'due before tomorrow' if you wanted to include tasks due today as well
sort by due
```

With these tasks:

- [ ] Test task due 15 days ago 📅 2022-06-07
- [ ] Test task due 14 days ago 📅 2022-06-08
- [ ] Test task due 13 days ago 📅 2022-06-09
- [ ] Test task due 12 days ago 📅 2022-06-10
- [ ] Test task due 01 days ago 📅 2022-06-21
- [ ] Test task today 📅 2022-06-22
- [ ] Test task tomorrow 📅 2022-06-23

I get these results (on 22 June):

Note how I used a range of tasks on different dates, to make it easy to adjust the boundaries in the query and easily test the results.

[azeem-SC]

Thanks a lot.
The magic phrase for this query '15 days ago' is not mentioned in the documentation.

[claremacrae]

The magic phrase for this query '15 days ago' is not mentioned in the documentation.

Good point. I've made a note to add it to the docs somewhere. Thanks.

[claremacrae]

Just to note that days ago is now included in the examples in the rocs, which will be published when I next do a release, in the next few days. PR: #828

[azeem-SC]

Thanks for the reply, I have now included this query in my daily routine. It's been very helpful