What I’m trying to do
I’m creating a note template for weekly notes where I want to see
- All the notes created in that week
- All the notes edited in that week
Things I have tried
My solution:
TABLE date, note-type, file.folder, file.mday
WHERE date(file.cday).year = date(this.file.cday).year
WHERE date(file.cday).weekyear = date(this.file.cday).weekyear
TABLE date, note-type, file.folder, file.mday
WHERE date(file.mday).year = date(this.file.cday).year
WHERE date(file.mday).weekyear = date(this.file.cday).weekyear
My help request:
Here’s the problem:
In the second table I’d like to see all the notes edited that week, but I’d also like to hide notes that were created that same week (I already have the 1st table for them).
How can I make it show older (than the note’s week) notes only?
I’ve tried adding many different “wheres”, these are 2 of my last attempts as example:
-
WHERE date(file.cday).year + date(file.cday).weekyear != date(this.file.cday).year + date(this.file.cday).weekyear
-
WHERE date(file.cday).weekyear != date(this.file.cday).weekyear
Both worked, but I think these solutions will give me problems in the future years.
Any ideas?