What I’m trying to do
Im trying to pull into my Weekly note via Dataview query all the bullets under a specific heading in Dataview, but only for the daily notes over the past week
In my Daily note, I have
" # Hello world
Events
- bullet 1
- bullet 2"
The daily notes also have a property “type” = daily
Things I have tried
When I use this dataview query, I successfully get a table with all the bullets under the Events section, but it pulls in all my Daily notes instead of just the past week
TABLE WITHOUT ID file.link as Date, L.text as Events
WHERE type = "daily"
FLATTEN file.lists as L
WHERE meta(L.section).subpath = "Events"
SORT file.name desc
So I tried adding the following below the subpath
WHERE file.ctime <= 2024-05-05 and file.ctime >= 2024-05-11
But it returns blanks and whatever was found by the query disappears (i get returned a blank table)
I tried looking through the previous queries but they dont seem to have any that filter the time period of the filename. Any help would be appreciated