Queries are the single biggest limitation of logseq - regular users do not stand a chance of writing an advanced query themselves - therefore either copy&pasting a query from the internet works or it doesn’t.
The query below is working for me, so that is a start, but here is what I am missing: I capture other data in pages, and then add the date to that page’s name or property block or any random block within the page.
I would like to see all of those pages show up as well, not just journal entries, as that is all stuff I worked on on that day.
Query that works for me:
{:title "⌛ ON THIS DAY"
:query [:find (pull ?b [*])
:in $ ?today
:where
[?b :block/page ?p]
[?p :block/journal? true]
[?p :block/journal-day ?jd]
[(- ?today ?jd) ?days]
[(mod ?days 10000) ?r]
[(= 0 ?r)]
[(> ?days 0)]]
:inputs [:today]
:collapsed? false}