What I’m trying to do
Things I have tried
I am trying to create a dataview table to show all the files I created on a certain day.
I use a filter like WHERE file.cday = date(today) or date(2023-05-11)
Both options work fine when I use them in today’s daily note, but ofcourse it doesn’t work on yesterdays daily note. Then I could use date(yesterday) but this does not work on older days.
So I started testing variables that would generate the exact date that corresponds to the creation date of my daily notes.
First thing I tried is using the filename of the note, after all, that is named after the date it was created on.
Unfortunately WHERE file.cday = date(file.name) or file.cday = date(“file.name”) does not work.
Then I tried using YAML fields on my daily notes that I could automatically fill with the creation date by using Templater, either as Frontmatter fields, or as inline fields.
So I would have something like
creadate: 2023-05-11
But again, unfortunately my code: WHERE file.cday = date(creadate)
or WHERE file.cday = date(“creadate”) does not work either.
After spending several hours after midnight I am getting desperate. Nothing seems to work. I am wondering if te problem lies in my first brain or in my second brain 
Is there anybody out there who could hand me a solution, or explain to me what I am doing wrong?
Anyway, have a great day you all.
