What I’m trying to do
Hello! I was following Armin Pfarr’s guide for “Organizing Historical Eras with Obsidian and Dataview” (copy-pasting the query) to set up notes for time periods listing notes about events and people who lived or died in the period:
However when I wanted to include events without a specified month or day the whole thing fell apart.
I found a thread from @Altostratus asking about the exact same thing but as I’m completely incompetent when it comes to DQL/SQL/any kind of coding really, I couldn’t really implement it
In short what I’m trying to do is:
- Make tables under a note with a specified start and end date (time period note)
- Display all notes tagged with #type/event, #type/movement and #type/person in the respective tables (one for events, one for movements (for both to include also events/movements that were taking place in the period even if they started earlier or ended later), one for people born in the period, one for people who died in the time period)
- Display the “category:”, “start:” and “end:” dates (or “life:” and “birth:”) from frontmatter
- Include BC dates (formatted as “-yyyy-MM-dd”)
- Include dates that either include only the year or the year and the month, without the day
- Display dates as “dd MMMM yyyy G”
- Calculate (and display) duration (or age) in years and months
Things I have tried
I’ve asked around on discord and even tried to use chatgpt for the first time in my life but every time it managed to get something to work, something else broke.