Hi @Mario2 ,
After getting their phone number and date, using add function module subtract 1 day from it so that you get a day before appointment , add save that to data store in Make .
and then create another scenario to run on a specific time on which you want to send SMS , Search datastore by current date and if record is found, send SMS on that number .