## On This Day... ```dataview LIST FROM "DevLog/log" WHERE dateformat(file.day, "MM-dd") = dateformat(this.file.day, "MM-dd") ``` --- ## Notes Created Today ```dataview TABLE created, updated as modified, tags, type, status FROM "DevLog" AND !"DevLog/log" WHERE contains(dateformat(file.ctime, "YYYY-MM-dd"), dateformat(this.file.day, "YYYY-MM-dd")) ``` --- [[DevLog/log/2021-10-25|2021-10-25]] <== <button class="date_button_today">Today</button> ==> [[DevLog/log/2021-11-01|2021-11-01]] #### Inputs #### Notes - [[sqlite3]] <https://stackoverflow.com/a/40091114/12339658> how to script with SQLite3 - `sqlite3 database.db < file.sql`