Possible to make "Select Field" change when desire day is come?

[fire_kid]

I want to make a tv database for ongoing tv shows. as an example “Loki” tv series it’s first season air will finish 14th july 2021. i added in my base. i want to change the select status to “Finish” if 14th july 2021 day come. is it possible?

[Kamille_Parks]

Set an Automation to trigger when a record in that table matches the condition: {Date} field = today

Add an Update record step that changes the {Select} field’s value to “Finish”