Airtable Search Records - Multiple Criteria : dates and text

[Admin_PL]

Hi,
I am struggling building a Search Record Airtable module. I would like to find all records for a specific User ID, for which payment date is between a start date and an end date.
I managed to use the AND () at the beginning of my formula in order to test with another text field, but it isnt working with dates.
Does anyone have an idea on how I could fix this ?
Thanks !

[digiPanda_Automation]

Hi @Admin_PL,

You can try this formula, and also make sure that the field names are exact and that the dates passed are in the same format as in Airtable.

AND(
{Lead} = “Naveen Rawat”,
IS_AFTER({Deadline}, DATETIME_PARSE(“06-19-2025”)),
IS_BEFORE({Deadline}, DATETIME_PARSE(“06-24-2025”))
)

Best regards,
Digipanda Consulting Pvt. Ltd
@digiPanda_Automation

[Admin_PL]

Hi thanks, it worked and here is what I actually did in order to make sure format are exactly the same within make / airtable