Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Query by modified date field

Topic Labels: API
400 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I’m trying to figure out a way to use the API to get all records modified TODAY(). When I retrieve records with the API I can see the createdTime field, but no modifiedTime field though the documentation says it exists.

Does anyone know of a formula that I can use to get all records modified TODAY()?

Thanks!

2 Replies 2

Hey @Daniel_Dow

There is actually a function you can use in filterByFormula called LAST_MODIFIED_TIME() for this purpose. Eg:

filterByFormula=IS_AFTER(LAST_MODIFIED_TIME()%2C+\"2021-01-25T14%3A23%3A41.000Z\")

Best,
Anthony

Thanks! I’ll try that!