Dataview to display only notes within date rangeÍ

What I’m trying to do

Use a simple dataview query to show books I read in 2024.

Query:

LIST
FROM
[[book notes]]
WHERE date-finished <=2024-12-31 and date-finished >=2024-01-0

But it returns:

image

Here’s my metadata:

image

I’m assuming that last one should really have a “1” at the end. Anyways, given your properties are true dates you can’t compare them to pure text. You need to compare them to actual dates.

So for starters try this variant:

WHERE date-finished <= date(2024-12-31) and date-finished >= date(2024-01-01)
2 Likes

That worked! Many thanks! :grinning: