Remove time from formula with date

[zaidfalih]

I have an Airtable base with two tables: “PT” (where students submit a form to reserve a date) and “Available time on Math Classes” (which lists all possible date/time slots as text in the format “M/D/YYYY h:mm A” as a linked record). In PT, after a student picks the first date, I use a formula to calculate three more weekly dates. Then I add a filter to find each date in “Available time on Math Classes” and hide them, so whenever the students are willing to book a date and time the other students can't book the same date/time.


Despite having matching text formats (and manual searches confirming these slots exist), the Find records step in the automation always returns “No records found.” I need help pinpointing why the automation won’t recognize an exact text match and ensuring these additional dates are properly found and marked as booked. 

Or I need a way that could hide the other three dates from “Available time on Math Classes”. 

Note: 1- the “Available time on Math Classes” contains the date in text format like this "2/8/2025 2:00 PM". 
2- “Available time on Math Classes” has a linked record to "PT" Table.
3- PT has the form that is used for student registration.
4- PT also has three formulas that add a week for the date selected.
5-  what I want is a way remove the other three dates from the dropdown that comes from “Available time on Math Classes”.

Thanks in advance

[TheTimeSavingCo]

Hmm, this is how my data's set up:

And the automation's 'Find record' step was able to find the next 3 records:

Link to base

I assume you're putting a DATETIME_FORMAT for all of your formula fields, right? Could I double check that you've re-tested the trigger to load up the latest data before testing the 'Find record' action?