Return record that matches certain criteria from Airtable

[Admin_Team]

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:

[CharlieF]

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!

[Admin_Team]

That worked! Thank you so much!