I think you probably want to use file.cday to identify the file’s creation day, and this.file.day to identify the date in the current file’s title. This query worked for me:
WHERE file.cday = this.file.day
If you’re using Windows this should work fine. If you happen to be using Linux, please note that Linux file creation dates aren’t stored the same way, and you may find that you don’t see the notes you expect.
Now i actually want to see all the daily notes in a week note. For this i insert the inline field “week::” in the daily note as well. Is there something similar to “this.file.day” also for week and month?
I would like to list the dailynotes from the week in the week note and all daily notes from a month in a month note.
WHERE date(datecreated).month = this.file.day.month
For weeks: You are on the right track with weekyear!
Weeks are potentially a little more complicated: there are apparently two different numbering systems for weeks depending on how you define the first week of a year. For example, January 1 2022 was a Saturday; what is week 1 for 2022?
Thus I would highly recommend not making your own week field and instead comparing the weekyear fields of two dates, since they’ll be in the same numbering system.