Daily Note that contains links to all notes with the same historical dates

What I’m trying to do

I would like to create a Daily Note that contains links to all notes with certain dates in the titles. For example, I have several hundred notes each one for a specific historical musical performance, and each of which has the performance date in the title. I would like my recurring Daily Note to include links to the notes with “today’s” date. So, on December 1, 2024, I want my Daily Note to automatically provide with links to the notes with titles “1980-12-01” and “1975-12-01.” Then, December 2’s Daily Note would provide links to “1984-12-02” and “1966-12-02.”

Things I have tried

The answers provided seem to focus on “dates created” or modified.

Hello.

If the daily notes are in yyyy-MM-dd format and the other files have titles with dates in the same format, Dataview can query files that match titles with the same day and month:

```dataview
TABLE WITHOUT ID
	link(file.link, dateformat(file.day, "ccc, dd MMMM yyyy")) AS 📅
FROM
	""
WHERE
	 file.day.day = this.file.day.day
	AND 
	file.day.month = this.file.day.month
SORT 
	file.link
	DESC
```
1 Like

That worked like a charm. Thank you!

1 Like

If Hampton’s suggestion worked out, please mark it as solved (check the “solved” checkbox in their post). Thanks!

1 Like

Try a templater template. Somthing like this will insert a codeblock for an embedded query. I use it in my daily note - each daily note has todays date as a title.

<% “```query” %>
<% tp.date.now(“MM-DD”) + " " + “-”

  • tp.date.now(“YYYY-MM-DD”)%>
    <% “```” %>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.