I am having trouble figuring out how to set up a script that runs daily. What I want is to receive an email one month before an item's expiration date in our database. I set up a calculated field that calculates this reminder date.
Here is my issue. How do I set a script that, once per day, checks to see if today's date matches the reminder date? Then, once a year when it does match, it'll send out an email. I know how to set up a script to send an email and have done this previously where it sends an email when one clicks on a button, but I don't know how to have it run the script once a day and send an email when the reminder date is today.
Help is greatly appreciated. Thank you.