Dataview uses Luxon for dates format (luxon/formatting.md at master · moment/luxon · GitHub). As you can see you’re not using the correct tokens - pay attention to upper / lower cases - for example DD is different from dd
if you’re using a title with the format “YYYY-MM-DD something else or not”, then you have an implicit field called file.day, an explicit date associated with the file title (see docs). I.e., you have automatically a valid date (not a string, as in file.name) to compare with other dates.
So, basically you only need something like WHERE file.day = date(today)
The other great guys, have given you some suggestions as to why it doesn’t work as you intended it to with the following script:
I’m only here to give you an alternate query, which could have helped you identify the culprit/errors/features/… of your query.
```dataview
TABLE WITHOUT ID file.name, dateformat(date(today), "YYYY-MM-DD-dddd")
FROM "Daily Notes"
```
I often find myself doing table queries like this, especially if I’m unsure on what to do with the WHERE section. I then just add the fields I’d like to use in the WHERE section, as columns in the query, to check that they actually holds the value I’m expecting them to.
This can help me identify various errors, like in your case the date format, and in some other cases whether the field you’re wanting to check is a link, or just a string, and so on.
If the output is overwhelming, you could toss a LIMIT 30 (or similar) at the end of the query to limit the amount of entries returned.