Date dependent email triggers
I mostly just use UE to trigger emails when a form is submitted, but I have a potential requirement for emails to be triggered depending upon particular dates.
The scenario is where we have a table of users, and a related table of tour itineraries. So any given user can add multiple itineraries. The itineraries have a valid from date and a valid to date.
Would it be possible to trigger an email to the user when the valid to date is reached? We can set it so that the itinerary doesn't appear on the site after the valid to date, but it would be useful if the user could be notified so that they know to take any necessary action.