Hi I have a question. What (or how) would be the best way to do an email notification like this.
I have a date I do a datediff against. an insurance expire date and if the date is within the next 30 days of NOW() an email gets sent to the person in charge.
But the problem is the dates keep getting queried daily so the email will keep getting sent until the date is not 30 days from NOW().
What would the best work around for this? I only need the email to go out once and then the ideally the person should update the insurance expire date. But until the expire date gets updated emails get sent.
Thank You
I have a date I do a datediff against. an insurance expire date and if the date is within the next 30 days of NOW() an email gets sent to the person in charge.
But the problem is the dates keep getting queried daily so the email will keep getting sent until the date is not 30 days from NOW().
What would the best work around for this? I only need the email to go out once and then the ideally the person should update the insurance expire date. But until the expire date gets updated emails get sent.
Thank You