Help me please (partial dates)

[Cindy_Shapiro]

I want to do a filterbyformula search through the api in a date field. My field is an ISO date field in YYYY-MM-DD format. Basically, I want to do a “select” call to the DB, with a filterbyformula, but only looking for a record that equals “today”, just with today’s date, but not time! (Too specific, and would fail!) So I would need to match 2019-06-12, for example, but not the full ISO string. How would I write that filterbyformula code in nodejs? It’s a headscratcher?

[Andrew_Johnson1]

You will want to use the DATETIME_DIFF function

For example.

DATETIME_DIFF(TODAY(), {Date A}, ‘days’)

The above formula will return the difference between in days between Today and the field {Date A}
If the difference is zero it means that the recrod’s date field is equal to today.

You may also want to see this link for a complete list of all the functions available

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...