Hello!
I’ve searched for an answer in the forum and tried messing with my existing query but i’m going nowhere fast.
I’m not a coder so i apologise for the noobiness.
What I’m trying to do
I’ve installed dataview and am using it to get my old unfinished tasks and present them in a daily note under a section called ‘leftovers’. I want to present myself with tasks where the due date has passed.
I’m using this query which i got from the original youtube vid that sent me down this (wonderful) rabbit hole…
This is fine if i dont fall behind or defer some tasks for a day or two or if i’m v organised with my due dates but i want a catch all for unfinished stuff in the past. If i remove the ‘date’ line then i get all the open tasks which dont have old due dates.
1.You know what it’s like…. You start watching one thing and then before you know it you’re installing plugins you have no right to use and it all seems so easy… but then the shu ha ri hits you and you realise you’re very shu and need help….
2.DQL is fine, i just want to see my old unfinished tasks
So, you’re using the calendar emoji (as in Tasks plugin) instead of an inline field like my task [due:: 2022-09-12]. If the right emoji dataview recognize them as similar to due key.
I’m not sure about your goal, but start with this:
```dataview
TASK
WHERE !completed AND due
WHERE due <= date(today)
```
date(today) is a dynamic value, i.e., it changes everyday. if you want a fixed date use something like date(2022-09-01);
<= means «equal or less than» - if “equal” not relevant you can use only <