My file names are in YYYY-MM-DD-dddd format, but I can’t find a way to identify the MM from file name and then get file.day to return a valid date minus one month.
Instead of returning 2021-08 for a daily note created today, I want the template to return 2021-07. This works as a handwritten dataview query:
list from "journal"
where contains(file.name, "2021-07")
sort file.name asc
But I have to edit the ‘YYYY-MM’ each month, rather than just have the template create the previous month automatically.
This query…
LIST FROM "journal"
WHERE file.day.month = this.file.day.month - 1
sort file.name asc
…kind of works, but it lists every note created in every July (if added to notes from August 2021) in every single year. I’m trying to narrow it down to July 2021 (in this example).
It also doesn’t work for notes in January. Presumably, with the minus one syntax, it is looking for a month called 00, and it returns no records at all.
I think I will look hard at your hint tomorrow and try to follow the clew. My brain is frazzled.
Thanks to you both.
Angel