Dataview List Statement - Debug Help

What I’m trying to do

I am trying to list all files in my vault (notes) which were created on the date of this particular daily note.

Things I have tried

Here is the LIST statement:

LIST FROM "" WHERE file.cday = date("<%"YYYY-MM-DD", 0, tp.file.title, "YYYY-MM-DD") %>") SORT file.ctime asc

Here is the error I am seeing:

This looks like it should work. Any help would be most appreciated.


A query such as that will not work when viewed as a template. You need to insert the template into a new (or another test) file, and then check whether the query is valid or not.

In that regard, it’s very useful to make the template into a command and bind that to a key to trigger the template. In my test setup I’ve got an intermediate template named “xTemplate” which I’ve bound to Ctrl + Cmd + X. This I change to my liking, and then insert the template into a test file until I’m satisfied, and move it over to the real template where I want that new functionality.

Thank you