This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The Reminder Interval Text Input tool has the number of lead days. Append this to the input data and use a formula to only pass the dates where the difference between that date and today is less than the lead days. I also included a clause to ignore renewal before today. This is assuming that you'll actually get to them before the renewal date and once renewed, the renewal date will be updated.
Change the Browse to an email tool and schedule this daily.
Are you working with just Alteryx Designer? Designer will only be able to notify you of things when a workflow is run manually. You would need a server or scheduler licence for this to happen automatically.
You could set up a workflow something like the attached, which will error to notify you of dates within the next month each time it runs. The browse shows the records.