Hello. I use Periodic Notes plugin to create Daily notes (title formatted as YYYY-MM-DD) in Journal/Daily and Weekly notes (title formatted as gggg-[W]ww, for example 2023-W31) in Journal/Weekly. My daily notes contain my daily tasks. I use Templater to automatically link each Daily note to its respective Weekly note, and vice versa (as in the screenshot below).
I’m getting started with Dataview, and I’m trying to make a query to see what tasks I haven’t completed from last week and this week.
- Perform some calculation and formatting to get the date with format similar to the Weekly notes from last week and this week
outgoing([[ the weekly note file name ]])to look at all the daily notes of that week
- Check unfinished tasks with
I’m getting stuck at step 1, I’ve been trying to work around with
dateformat() (as in the screenshot below) but seems like I couldn’t get the correct name for my Weekly note.
I don’t think about directly calling days from last week using calculation with
file.mday because I usually plan a head certain tasks for every day in the next week, so the creation date is not actually from that week, and some days I forget to check the tasks so they’re not modified at all.
I’d really appreciate some help, thanks a lot!