Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Suspected Bug in filterByFormula feature (AirTable API) (thoroughly tested)

Topic Labels: Formulas
330 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there, I have written and tested a formula (it works) -
AND(IS_AFTER({Invoice Date}, “12/31/2020”), IS_BEFORE({Invoice Date}, “12/31/2021”))

Where invoice date is a valid date field.
This works perfectly well on the table interface, returning 0s and 1s as needed.
When I use the exact same formula on filterByFormula parameter in the API, it returns (NodeJS) -

AirtableError {
error: ‘INVALID_FILTER_BY_FORMULA’,
message: ‘The formula for filtering records is invalid: Invalid formula. Please check your formula text.’,
statusCode: 422
}

I couldn’t find any documentation saying that AND could not be used.
*note - I already succeeded using only one date formula - IS AFTER

0 Replies 0