What I’m trying to do
I want to write a dataview query which displays notes in a folder where the dateReadwise property (a date field) is equal to the name of today’s note name, in YYYY-MM-DD format.
Things I have tried
TABLE author as "Author", dateformat(file.ctime, " HH:mm") as "Readwise Date", this.file.name as "File Date", dateReadwise
FROM "Atlas/Sources/Readwise/Articles"
WHERE date(dateReadwise, "yyyy-MM-dd") = date(today)
SORT file.ctime DESC
The query returns no results, even when there should be matching note names and dateReadiwse properties.