What I’m trying to do
Hello I have a bunch of notes that I use as a reading list. Besides obvious fields (author, title, year of publication…), each note as a “finished” field with the date in this format “2022-06-15”.
What I want to do is to get a table with all the books I’ve read in 2022 so I guess I want to filter all those books that in this date field contain “2022”
Things I have tried
As suggested here I’m trying to filter this date field like this:
TABLE WITHOUT ID order as Order, status as Status, "![|60](" + cover + ")" as Cover, link(file.link, title) as Title, author as Author, join(list(publisher, publish)) as Publisher, genre as Genre, finished as FINISHED FROM #📚Book **WHERE finished.year = "2023"** SORT order ASC, status DESC, file.ctime ASC
This doesn’t work. If I put this code it works:
WHERE finished.year = date(now).year
but I’d like to be able to have the table returning books read during 2022 so, how can I calculate “date(now).year - 1 year”?
Any help appreciated