https://docs.datomic.com/on-prem/query/query.html#calling-instance-methods

Just evaluating (< (Date.) (Date.)) in the repl gives a ClassCastException, so no wonder if Datomic does as well.

Should be able to do something like [(.before ?date ?contract-end)] though.

right, thanks. That seems more correct.

it's just giving me still CCE... :thinking_face:

but probably the problem is elsewhere... the entity value is an inst though

Datomic supports comparison on dates.

Is conn a connection or db?

(def older (Date.))
(d/q '[:find ?contract-end => #{[#inst "2022-02-01T12:56:01.393-00:00"]}
       :in $ ?date
       :where
       [?e :contract/end ?contract-end]
       [(> ?date ?contract-end)]]
       [[1 :contract/end (Date.)]
        [2 :contract/end older]]
     (Date.)))

thanks!

Right, sorry about that false lead.

no worries

@U4GEXTNGZ I think your class cast may be about trying to cast a connection to a db, nothing about dates. Your db var is named conn which is fishy

What is the actual exception?

no sorry about that... I am using d/db to get the conn... I am used to use datahike and there usually it's a connection that is used to query.

there was actually a (get-else in the query that I did not recognize as the problem here

it was giving me a string when there is no contract-end there

> it was giving me a string when there is no contract-end there This is wired. when it don't have contract/end, it should simply don't match

(require '[datomic.client.api :as d])
(let [conn (-> {:server-type :dev-local
                :system      "hello"}
             d/client
             (doto (d/delete-database {:db-name "hello"})
                   (d/create-database {:db-name "hello"}))
             (d/connect {:db-name "hello"})
             (doto (d/transact {:tx-data [{:db/ident       :contract/id
                                           :db/valueType   :db.type/string
                                           :db/cardinality :db.cardinality/one}
                                          {:db/ident       :contract/end
                                           :db/valueType   :db.type/instant
                                           :db/cardinality :db.cardinality/one}]})))
      {:keys [db-after]} (d/transact conn
                           {:tx-data [{:contract/id "1"}
                                      {:contract/id  "2"
                                       :contract/end #inst"2000"}
                                      {:contract/id  "3"
                                       :contract/end #inst"3000"}]})]
  (d/q '[:find ?e ?contract-end
         :in $ ?date
         :where
         [?e :contract/end ?contract-end]
         [(< ?date ?contract-end)]]
    db-after
    (java.util.Date.)))

=> [[83562883711053 #inst"3000-01-01T00:00:00.000-00:00"]]

see

(d/q '[:find ?contract-end => #{[#inst "2022-02-01T12:56:01.393-00:00"]}
       :in $ ?date
       :where
       [?e :contract/end ?contract-end]
       [(> ?date ?contract-end)]]
       [[1 :contract/end (Date.)]
        [2 :contract/end older]
        [3 :contract/end "-"]]
     (java.util.Date.)))

; eval (current-form): (d/q '[:find ?contract-end :in $ ?date :where [?e :...
; (err) Execution error (ClassCastException) at (REPL:1).
; (err) null

yeah, sorry. there is a get-else that tripped me off. it inserted a string where there should be an inst.

to use datomic.api (peer api) you can change to

conn (-> "datomic:"
       (doto d/delete-database
             d/create-database)
       d/connect)

You are creating an invalid database: [3 :contract/end "-"]