Hi.
Considering your long and descriptive answer, it’s better start from a basic “point” and later we can discuss other details.
As obvious conclusion, the main point is… dates.
My main suggestion is this: for dataview purposes, every entries (titles, values in fields, etc.) with reference to dates should use the format YYYY-MM-DD.
With this format you can work with dates in a more flexible way:
- extract date from title;
- make some durations calculations with the values (dates) in your fields;
- define the format you want to present in results (with the function
dateformat()you can choose the output format); - you can do this: «I capture the date that a file scheduled within the YAML of each note under “Due_Date” so cannot use the .month or .year adjuncts which one could use with the file.ctime or file.mtime.»;
- no need to use templater expressions like
<% tp.file.title %>; - etc.
For weekly, monthly and yearly notes, it’s necessary other approach.
In weekly notes (format gggg-[W]ww), monthly or yearly, titles aren’t a readable “date” for dataview and the more immediate date to capture is the note creation date (as I said before to @Create). If this isn’t a problem for you, then is possible to solve your wanted queries.
Before any other step, what you think about this?
(btw, by default dataview uses ISO8601 dates - Data Annotation - Dataview -, but it’s possible to extract results in luxon format)