Filtering records by date in the API doesn't appear to work as described here: https://developers.smartsuite.com/docs/solution-data/records/sort-filter
The following request returns all records even though the date is in the future.
{
"filter": {
"operator": "and",
"fields": [{
"field": "last_updated",
"comparison": "is_on_or_after",
"value": {
"date_mode": "exact_date",
"date_mode_value": "2025-06-19T01:19:41.235000Z"
}
}]
}
}