[URGENT HELP] Error 422 in Make.com + Airtable – “Invalid Formula” in Search Records even with correct fields

The problem

I'm constantly getting this error:

pgsql

CopiarEditar

RuntimeError t422] The formula for filtering records is invalid: Invalid formula. Please check your formula text.

Even though all the Airtable field names are correct, Make.com keeps rejecting the formula.

🧩 Airtable Table Details:

• Table Name: Table 1

• Fields:

  • Nome do Cliente (Single line text)

  • Produto

  • Qtd

  • Valor do produto

  • Valor Total

  • Data da Entrega Confirmed: Date with time format

Formulas tested (all returned 422 errors in Make):

plaintext

CopiarEditar

AND( {Nome do Cliente} != "", IS_AFTER({Data da Entrega}, DATEADD(TODAY(), -5, 'days')) )

Also tried with IS_BEFORE, simplified formulas, and also using "ok" in a formula field with static text — still getting the error.

Formula that worked in a previous database:

plaintext

CopiarEditar

AND( {Cliente} != "", IS_AFTER({Entrega}, DATEADD(TODAY(), -30, 'days')) )

But this time the fields are different (Nome do Cliente and Data da Entrega), and the same logic doesn't work.

Notes:

• Field names are 100% correct (copied directly from Airtable).

• The date field is properly formatted with date and time.

• Formula works perfectly inside Airtable, just not in the Make.com “Search Records” module.

• Tried escaping quotes, pasting from Notepad, switching fields — still fails.

What I need:

1. Help from someone who successfully used a formula with DATEADD and IS_AFTER/IS_BEFORE in Make.com.

2. A known working example of a filter formula with Airtable dates.

3. Any trick to avoid silent formatting issues or “invisible character” errors in formulas.