Help

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

Topic Labels: Formulas
579 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Yoav_Shotland
4 - Data Explorer
4 - Data Explorer

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