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