Make.com formula syntax rules for Airtable

[mfjsullivan]

I'm using make.com and have a connection to Airtable and am trying to do a simple search on a table. I can't find a guide on Make or Airtable on the syntax required in Make's Formula field.

I would like to do something like the following logic

{Email}='1.email' AND {Date} >= CURRENTDATE

Where Email and Date are fields in the table I want to search. I can't seem to find the equivalent of CURRENTDATE in airtalble's Formula Playground or elsewhere.

[kuovonne · Accepted solution]

You need to create an Airtable formula for the search module. See the Formula Field Reference for how to create a formula. There is no CURRENTDATE function in Airtable's formula language. You may want to use TODAY() or NOW().

You might want something like this ... (the dates might be flip-flopped).
AND({Email}='1.email', DATETIME_DIFF({Date},TODAY(), 'day')>=0)

[mfjsullivan]

Thank you very much, that worked. I was surprised it did because I wasn't sure how the query would work. I guess it retrieves all records w/ a matching email, and then looks at the Date one-by-one using the formula. I hope in the future, AirTable implements a simple function CURRENT_DATE.