~ Calendar
Showing the most recent daily notes, based on how they are named.
TABLE WITHOUT ID
file.link as "Daily Notes",
regexreplace(file.path, ".*/([^/]+)/[^/]+$", "$1") as "Parent Folder"
FROM "Calendar/Days"
WHERE regextest("\\d{4}-\\d{2}-\\d{2}", file.name)
SORT regexreplace(file.name, ".*?(\\d{4}-\\d{2}-\\d{2}).*", "$1") DESC
LIMIT 40