Create table on Daily Note of all files created on that same day

[TheSJMorris]

Please forgive me if this has been asked and answered. I could not find anything on it.

GOAL: List all files created on the same day as a "today's daily note" from the Daily notes Core Plugin

OBJECTIVES:

1. Use Daily notes as a reference to track what notes were created on THAT day
2. Track last date modified in the reference as well

ADDITIONAL DETAILS:

• I'm current trying to use a "Created::" field in a YAML header. I enter the day's date there in YYYY-MM-DD format
• I don't care HOW I do this ... only that I do it

NOTE:
I read through the documentation on DQL and the Syntax ... I'm just not seeing anything that specifically does this task.

[DeutscheGabanna]

TABLE WITHOUT ID file.link AS "Notes created on that day" FROM "" WHERE file.cday = date(this.file.name) SORT file.name

[DeutscheGabanna]

[mnvwvnm]

if you use the file name in the format "YYYY-MM-DD" you can use this: WHERE file.cday = this.file.day > file.day is an implicit field (a date) in notes with a date in name.

[TheSJMorris]

Thank you @mnvwvnm This works! Appreciate the help.

[mnvwvnm]

2. Track last date modified in the reference as well

Dataview results are dynamic... they are a "data" "view" in the moment you run the query. This means that if you make any change to the file the propriety related with the modified date changes as well. So, if you create a list in yesterday note, once you change any file in that list today then the file goes away from yesterday query output!