Use of dataview for 'collecting' the files which were created over the day in daily notes with the help of a template

[Kaian]

What I’m trying to do

To link every created file of the day I linked them manually by “[[fileX]]” in my daily note for which I created a template like:
"

Appointments

ToDos

Notes

[[fileX]]

[[fileY]]

[[fileZ]]

"

For only three files this is not a hassle, but >10 I think about automation.

Things I have tried

I added the following in my template in the “# Note”-section:

TABLE file.ctime, file.name
WHERE date(file.ctime)=date(today)
LIMIT 10

but this didn’t work - no error but also no result

I tried also

LIST date
WHERE date >= date(2024-05-13)
LIMIT 10

but the result was mixed probably because I have files without the new properties function date in it.

Ok, I am not a programmer, I had a look at:
https://blacksmithgu.github.io/obsidian-dataview/reference/literals/
tried some functions and checked examples on YouTube from Sergio, Nicole and others.

What I have in nearly all my file is:
“Datum: YYYY-MM-DD-hh-mm, dd.” from my file template:

"

tags:

• /KN_
  Source:

---

Datum: {{date:YYYY-MM-DD-HH-mm, dd.}}

---

"
I tried in the properties section also date, but I could not manage to have the same ease like with the “Datum: {{date:YYYY-MM-DD-HH-mm, dd.}}” (no klick needed).
It would be great if there is an elegant solution in the properties section.

Any idea or hint on how to solve this problem would be very nice!

Thanks for your time reading this!

[Kaian]

The code solution for the above is:

```dataview
TABLE file.name AS “Datei Name”, file.cday AS “Erstellungsdatum”
FROM “”
WHERE date(today) = date(file.cday)
SORT file.cday ASC
```

for seven days:
```dataview
TABLE file.name AS “Datei Name”, file.cday AS “Erstellungsdatum”
FROM “”
WHERE date(today) - date(file.cday) <= dur(7 days)
SORT file.cday ASC
```

Code generated by ChatGPT
Input:
GER: “Gebe mir ein Code Beispiel für das Add-on “dataview” in Obsidian.md welches mir alle an dem aktuellen Tag generierten Dateien auflistet.”
EN: “Give me a code example for the add-on “dataview” in Obsidian.md which lists all files generated on the current day.”