## 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-04-25|2021-04-25]] <== <button class="date_button_today">Today</button> ==> [[DevLog/log/2021-04-27|2021-04-27]] - [[tsql]] / [[sqlite3]] - In vscode using the SQLite extention you can't use the command `PRAGMA foreign_keys = ON;` to enable foreign key constrains on your SQLite tables. - You'd think that would be kind of a high priority change especially since the change appears to be an easy 1 liner change? - Either way [I requested that the change be made asap](https://github.com/AlexCovizzi/vscode-sqlite/issues/60)