Not necessarily at the exact time, but something could be created to check the box on or after that time. The problem is that Airtable’s
NOW() function that looks at the “current” time isn’t refreshed constantly. Per the documentation, it only updates roughly every 15 minutes when a base is open, and roughly every hour when it’s closed. If this inaccuracy is tolerable, here’s how to pull it off.
Create a formula field with this formula (assuming the name of your date field is
NOW() >= Date
This will output a 1 when the current time is on or after your specified date. Now you can create an automation that triggers when that formula field outputs a 1, and updates the checkbox field for the triggering record.
However, if you just need some indicator of when the date and time has passed, you can do this without using an automation or a checkbox field and just alter that formula above to output a specific string when that time has passed:
IF(NOW() >= Date, "✅")