The names of my weekly periodic notes are formatted like YYYY-[W]WW. For example: 2024-W17.
I’m trying to write a query that tracks files modified last this week like so:
TABLE
WHERE file.mday.week = this.file.cday.week
However, this doesn’t work in these instances:
- I create the weekly note on a different week than the intended week
- (my repo is synced in a version control system) I clone the repo and now all the files have created day as the day I cloned the repository
How do I get the week number from the title of the file → 2024-W17, instead of via cday in dataview or dataviewjs?