Table API Query with Date/Time Field

Does anyone have a working example of using the GET tables/{tableId}/records API with a filter that references a date/time field?
I’ve tried numerous approached and consistently get an internal error back when sending the request. I would like to be able to find all records in a table that have a date/time field (either my own or _createdAt) which is at or beyond a specific date.

Hi @Lance,

You can do this but only with a string formatted datetime - I’ve used the following format YYYY-MM-DDTHH:MM:SSZ (i.e. 2021-12-15T00:00:00-05:00). This should work for either metadata columns or custom columns.

Let me know if you have any questions!

1 Like

Works great. I did not think to use the greaterThan and lessThan comparisons since the data appears like a string.