API doesn't respect IS_AFTER filter, issue also reported 3 years ago

Question

Previously reported issue: Getting all records modified after a date | Airtable Community

I’m calling Airtable passing

filterByFormula: "IS_AFTER(LAST_MODIFIED_TIME(), '2026-01-25T00:00:00.000Z')",
// filterByFormula: "IS_AFTER({Last Modified}, '2026-01-25T00:00:00.000Z')",

Last Modified is a formula column I created. Neither of them works.

Expected

Only return records that were edited after a certain date

Actual

It returns all records

Am I doing something wrong? Is it not supposed to work?

Are there workarounds for this?

TheTimeSavingCo · Answer

Hm as a datapoint I just tried this via Postman with both a GET and a POST and it works fine. Could you provide some screenshots of your data and the full body of your POST?

GET with URL params

https://api.airtable.com/v0/appz6YcyO3dXfqDWV/tblVg5MfRaHq9Cnvt?filterByFormula=IS_AFTER({Date}, '2026-01-25T00:00:00.000Z')

POST with JSON

URL

https://api.airtable.com/v0/appz6YcyO3dXfqDWV/tblVg5MfRaHq9Cnvt/listRecords

Body:

{
    "filterByFormula": "IS_AFTER({Date},'2026-01-25T00:00:00.000Z')"
}

Return:

{
    "records": [
        {
            "id": "recelxVi6HgvyfFeT",
            "createdTime": "2026-01-27T14:37:26.000Z",
            "fields": {
                "Date": "2026-01-28",
                "Calculation": 1
            }
        },
        {
            "id": "recmCfH2Xhij23hTl",
            "createdTime": "2026-01-27T14:36:29.000Z",
            "fields": {
                "Date": "2026-01-27",
                "Calculation": 1
            }
        }
    ]
}

Here’s my data:

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded