softech
6 months agoGuide
query with date field
trying to find out posts between two dates in "message" i have something like https://mycommunity/api/2.0/search?q=SELECT%20post_time,%20post_time_friendly%20FROM%20messages%20WHERE%20ipost_tim...
- 6 months ago
softech To get the accurate results, you can use the following query.
select post_time, post_time_friendly from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00