How to list only today's dailynote in a dv-list-query?

[Gewerd-Strauss]

Hello,

I have been using this query:

``` dataview
list
FROM "300 Personal/(301 DailyNotes)"
WHERE date = date(today)
```

for getting the today's note based on the frontmatter date field containing the date in format 2022-12-18. Now I have transitioned to the format yyyyMMDD (just removed the -, aka 20221218), and I cannot figure out how to change the dataview query accordingly.

Anyone know how to do this properly?

[AB1908]

Alas, this is painful. In the where, do something along the lines of date(regexreplace(date)) (invalid, please work this out) to convert it into a usable date. There should be other ideas but this is the first I can think of.