Filter a query result by :block/created-at

Questions & Help Queries
1

Here is my little query:

#+BEGIN_QUERY
{:title "Blocks created last week"
 :query [
                :find ?start (pull ?b [:block/created-at :block/updated-at] )
                :in $ ?start 
                :where
                       [?b :block/created-at ?d]
                       [(>= ?d ?start)] 
         ]
:inputs [:-7d ]}
#+END_QUERY

As you can see if you run it, the input it is passing to the query is date string or int like 20240315 in while the :block/created-at is a timestamp like 1705528859459 . Is there a way to convert from one to another so that the comparison make sense?

Thanks,
Max

2

Welcome. Check this post

3

Thank you very much! I didn’t noticed the -start and -end suffixes.