Querying Obsidian Notes created since a date with obsidian-dataview (Misc)

Category: Misc

The dataview plugin for Obsidian allows you to run queries against your obsidian vault (for example, to create a Related Items section).

This snippet provides a DQL query which lists all notes created after a certain date

Details

  • Language: Misc

Snippet

TABLE WITHOUT ID 
 file.link as "link",
 file.path as "path"
WHERE file.cday > date(<DATE>)
AND file != this.file
SORT file.cday ASC

Usage Example

// Read the start date from a variable in the file
// i.e. start_date::2024-02-01
//
// Also exclude the daily notes folder
//
TABLE WITHOUT ID 
 file.link as "link",
 file.path as "path"
// exclude daily notes
FROM !"0000_Daily_Notes"
WHERE file.cday > date(this.start_date)
AND file != this.file
SORT file.cday ASC