Sqlfilter between

How do I use the sqlfilter between?

This doesn’t seem to work (t.date_creation:>:1697883386:<:1697883386)

I still get all 3 orders this thirdparty have made, and I would expect to either get the middle one or get nothing at all

"date_creation": 1697719790,
"date_creation": 1697883386,
"date_creation": 1698653358,