List finished tasks from yesterday's daily note

Basement
,
5

Ok. Let’s try with dataview.

  1. Completed tasks. (for all notes ignore FROM "", if any particular folder - or tag - specify FROM "yourdailynotefolderpath-or-#yourtag)
```dataview
TASK
FROM ""
WHERE completed
```
  1. Tasks completed from yesterday note. If you use the format (YYYY-MM-DD) on file name, you can do something like this:
```dataview
TASK
FROM ""
WHERE completed AND file.day = date(today) - dur(1day)
```

(“file.day” extract date from title)

Try and tell me if works as you wanted

EDIT: well, one problem. In this case dates are relative, not absolute. I.e, today is today and yesterday is yesterday. If you use this query in regular way, when you go back for example for the note a week ago, “yesterday” is the relative to today, not to the date of the daily note. To solve this is necessary other approach.
In this case, if you use templates via Templater to create your daily note, then is possible create a dataview “auto-query” with exact dates.
Query in template:

```dataview
TASK
FROM ""
WHERE completed AND file.day = date(<% tp.date.now() %>) - dur(1day)
```
1 Like