Dataview Q: how to show notes from a specific week

[erankatz]

Hi there!
I’m looking to create something like this:
I’m using Peridic Notes plugin to create a weekly note with a template. I want the template to include a dataview LIST of the daily notes created in that week (usually the weekly note will be created on a Saturday, so I want to see the notes created in the last week, Sun→Sat, total of 7 notes).

I did this:

LIST
FROM #daily_journal 
WHERE file.ctime >= date(today) - dur(7 day)
SORT file.ctime ASCENDING

which works but I guess that the date(today) - dur(7 day) part means that if I open this weekly note again on a later date, I’m gonna see different notes in the list (as “today” has changed).

For the life of me, I can’t find a way to have dataview to look at the creation date of the weekly note and calculate 7 days from that.

please help! Thanks

[anon12638239]

Perhaps the markdown file on the link below has something similar that you can adapt to your needs / syntax?

Dataview list based on PREVIOUS month

Thanks to @mnvwvnm and @Moonbase59 for being kind enough to share their time and wisdom. I am awed and grateful. For details of the dataview queries used in the journal, see the markdown file attached. Angel journal_dataview_queries.md (2.2 KB) Edit: I marked this post as the solution as it contains the final code. The solution was provided by @mnvwvnm and @Moonbase59 in the posts above.

Angel

[mnvwvnm]

To close this help, please confirm if this (or @anon12638239 solution) works:

(using Templates, as discussed in Discord channel)

LIST
FROM #daily_journal 
WHERE file.day <= date({{date:YYYY-MM-DD}}) AND file.day >= date({{date:YYYY-MM-DD}}) - dur(7days)
SORT file.day ASC