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