Airtable formula error in 'search records' module in Make.com

[hauwi]

Hi. I am trying to construct a formula in a Make.com search records module. The module is the trigger and I've been trying:

AND({Ind Doc}!=BLANK(),(DATETIME_DIFF(NOW(),{Record Created}(),"days")=14))

('Ind Doc' is an attachment field)

Any help would be appreciated. TIA. 😊

[ScottWorld · Accepted solution]

You have an extra set of parenthesis after your field named Record Created. Also, remember that Make’s search module for Airtable only support valid Airtable formulas, so you can test your formulas by creating a formula field in Airtable and seeing if it works there.

[hauwi]

Thank you @ScottWorld. Much appreciated. 😀