Return record that matches certain criteria from Airtable

Questions
,
1

Hi everybody! So a quick background. My scenario is linked to an Airtable that contain fields and along that it have “Status field” and “Follow-up Due Date” field. I’m trying to filter on the record that:

  • Have a status of pending
  • Follow-up Due Date matches the current date (the returned format is )

If i applied the formula Status = “Pending”, it returned the matched value just fine but when i try to add another criteria, it doesn’t work. Here’s my current formula:

AND({Status} = "Pending" , DATESTR("{Follow-up Due Date}")  = {{formatDate(now; "YYYY-MM-DD")}})

Here’s what i would return when i only apply the status filter for reference:

Screenshot 2025-04-09 at 9.22.14 PM
Screenshot 2025-04-09 at 9.22.14 PM1118×1548 206 KB

2

Hey there.

Try using DATE_TIME_FORMAT instead of DATESTR

Please try:

AND({Status} = "Pending", DATETIME_FORMAT({Follow-up Due Date}, 'YYYY-MM-DD') = "{{formatDate(now; "YYYY-MM-DD")}}")

If that doesn’t work, please ensure that:

  1. Your dates are both in the correct format
  2. Try adding a trim() round the date value
  3. Your Airtable {column names} are identical, and have no whitespace in the column. (Go into airtable, check follow up date column has no whitespace at the start.)

Hope this works!

3

That worked! Thank you so much!