Hi everyone! I recently set up, based also on Bryan Jenks video on daily notes (https://www.youtube.com/watch?v=5k4LfCVY0yQ&t=573s) a reviews system, where basically highlights for the Week, Month, and Year are all pulled from the daily notes. However, I have some issues regarding both aliases (they don’t get recognise) and also, with the naming. I prefer to call my monthly note (YYYY-MM) instead of his (YYYY-[M]MM), but in this case I don’t know how to set up the code. If I put just this.file.name instead of his code: replace(this.file.name, “M”, “”). It doesn’t work.
Below the code (I have a different synthax for “unequal” symbol, but it should not be a problem):
TABLE WITHOUT ID file.day.weekyear " AS Week, highlights
WHERE highlights != null
AND file.day.year number(substring(this.file.name, 0, 4))
AND dateformat(file.ctime, “yyyy-MM”) = replace(this.file.name, “M”, “”)