Dataview is not able to pull out the text from a section in a note. It’s used to list fields and metadata from the notes, or potentially text from a list or task item.
- That syntax using
from ... to ...
is not legal in any way. TheFROM ...
can be used to define the source folders (or tags) of the notes you want to query. - If you want to do regex matching, you need to use a function call like
regexmatch(file.name, "...regex...")
. - There is no function named
section()
in a DQL query. - To query related to the date of your notes, you might use
file.day
and compare to some variant related todate(now)
anddur(...)
to get to a year old notes - If all of your reflections and memories are written as list item, there was a similar request just a few days ago which you could try to adapt to your needs.
- If on the other hand, your daily notes also include pure text, you need to use javascript to extract that text.
In summary, I think you really need to read up on doing dataview queries, and try something simpler, and take it step by step. And do some research by searching this forum for similar solutions.