Run rule when Date/Time type field reach current date

[Muhammad Arif B]

I have requirement to update case state from Awaiting Info to Open and trigger email notification when Appointment Date (Date/Time type field) reach current date. Example : 

Case CS123456

Appointment Date : 2025-11-04 09:27:47

State : Awaiting Info

Once current date is 2025-11-04 09:27:47, CS123456 automatically move from Awaiting Info to Open and trigger notification.

Do you have any idea how I can fulfill this requirement? 

Thanks

[Ankur Bawiskar]

@Muhammad Arif B 

you can use flow designer for this

-> run flow when state moves to Awaiting Info

-> in that flow wait till Appointment Date

-> once that's crossed, update the State using "Update Record" flow action and then use "Send Notification" flow action or "Send Email" flow action to send email

see this link for help, it has approach for Variables i.e. flow will wait till Variable is updated, you can enhance it based on field

this link has approach from Anil lande on how your flow can wait till that variable is updated and once updated/filled, you can break the loop and proceed

How can w use wait for condition in flow designer for variable? 

Also an easier solution is shared there in the same above link, below is the image, it will wait till that Variable is empty, once not empty it will proceed

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏