HI, I am working on the logic how to correctly place the operators on how to get the specific date in the data base. For example, when I enter a date in the preview, everything that is in the database that I sourced from is included. My problem is how to get the specific data when I input a date, what is the same date only according to the data I will get. what is the correct logic for this so that I can get that solution.
Hello @Jan_Patrick_Dela_Rosa
Based on the logic you made, you should not get all records. You should get records with the EventDate greater than the selected time in the data picker component.
The data picker component and the record data field return timestamp, like: 1722507315633. (Thu Aug 01 2024 13:15:31 GMT+0300)
If you need records for a specific day, you will need to specify the interval between timestamps.
Example: EventData > 1722459660000 AND EventData < 1722507315633
You might find a useful operator here:
https://backendless.com/docs/js/data_search_with_dates.html
Regards