If you want to query for dates, I think you need to change the timestamp format to just, e.g., 20230306 . I've tested it locally (today is 20230306):
Query
#+BEGIN_QUERY
{
:title "Tasks completed yesterday"
:query [
:find (pull ?b [*])
:in $ ?start ?end
:where
[?b :block/properties ?properties]
[(get ?properties :completed) ?completed]
[(>= ?completed ?start)]
[(< ?completed ?end)]
]
:inputs [:yesterday :today]
}
#+END_QUERY
The query should show all tasks that were completed yesterday. After changing the timestamp format it finally worked.
The drawback is that you lose the link to a journal page...
If you want to query for dates, I think you need to change the timestamp format to just, e.g., 20230306 . I've tested it locally (today is 20230306):
Query
The query should show all tasks that were completed yesterday. After changing the timestamp format it finally worked.
The drawback is that you lose the link to a journal page...