#community-help

UNIX Timestamps and Search Condition Operators

TLDR Eshwar asked about using <= >= operators for a date field search option. Jason confirmed the operators but asked for curl commands to replicate the issue.

Powered by Struct AI
Aug 15, 2023 (1 month ago)
Eshwar
Photo of md5-6430f9b6a2ce8a5112b327de0f0266e7
Eshwar
02:22 PM
We have a date field where user can search for "is on or before" as well as "is on or after" conditions.

We are storing the date in unixtimestamp as the documentation suggested. Are <= >= right operators to use for the above use case? Because, its not working; I am wondering if we are missing something.
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
02:53 PM
Those are indeed the operators to use with the Unix timestamps stored as an int64 field.
02:53
Jason
02:53 PM
Could you give me a set of curl commands like this that replicates the issue?
Eshwar
Photo of md5-6430f9b6a2ce8a5112b327de0f0266e7
Eshwar
05:40 PM
hey jason, looking into it. will revert soon on this.