Trying to pull notes

[jasmeetchadha]

Hi - I am trying to pull the daily notes into a weekly note file at the end of the week. So I want to define a “where function” which looks for daily notes upto 7 days older than the weekly note creation date. (Not sure how to pull date of the weekly note wher the query is running). I can then use those past daily notes to summarise into weekly note.

I am using the below query but it seems to pull all notes. What am I doing wrong?

table file.mday as Created, Summary
from "6 Daily"
where file.day - date <= 7
sort file.cday asc

[blacksmithgu]

A few things:

1. file.day - date is a date computation that returns a duration, not a number
2. I'm not sure what date is.

I would write the query like this, assuming you have annotated the weekly note with the week it's from (like 2021-08-07 week or a Date:: inline field):

TABLE file.cday AS Created, Summary FROM "6 Daily"
WHERE file.day <= this.file.day AND file.day >= this.file.day - dur(7 days)
SORT file.mday ASC