Things I have tried
Given that,
in the daily log file, there is a date key in meta.
---
date: <% tp.date.now("YYYY-MM-DD") %>
---
in the weekly report file, there is also a date key in meta.
---
date: <% tp.date.now("YYYY-MM-DD") %>
---
What I want to do is, when the weekly report is created from templates, all the daily log from last week should be listed in a table via dataview extension.
What I’m trying to do
a minimal working example would like
```dataview
list from "06 Logs"
where (date >= date(2022-03-15)- dur(7 days)) and (date <= date(2022-03-15) - dur(1 days))
where contains(tags, "DailyLog")
sort date desc
for the automatic generating, now I would prefer using date variable like
this.file.date , file.cday instead of the fixed explicit date like “2022-03-15
therefore, the ideal is likely to using
```dataview
list from "06 Logs"
let reportDate = this.file.date
where (date >= reportDate- dur(7 days)) and (date <= reportDate - dur(1 days))
where contains(tags, "DailyLog")
sort date desc
Of course, the above code doesn’t work, so I’m here to ask for a solution ::
Thank you all in advance!
