Well, with your query you get the files created on the same date of your daily note. You can replace your query by this (with the format “YYYY-MM-DD” you can get a date with the implicit field file.day):
```dataview
TABLE file.ctime as "Created"
WHERE file.cday = this.file.day
SORT file.ctime DESC
```
Your second point… well, you have a problem! Dataview results are dynamic: what you see is the “actual” metadata, when you run the query. It’s a “view”. Modified date is also a dynamic date. The value in file.mday or file.mtime change every time you made modifications to your file. Then, if you use a query with the modification date this value changes accordingly.
This to say that you can’t have a “stable” table in a specific daily note. If your goal is «know all the files that I modified in this date", if in the next day you modify a file in that list then the file move out from results in the previous daily note query.