I've set up an automated email to a filtered data extension which utilizes some date logic. This automation runs each day and looks for a specific date. The data in the data extension this is pointing to never refreshes, it only appends new records. So, contacts who fall out of the date range of this automated email never drop off.
How would I set this to refresh before each send so I am only grabbing people who fall into the date criteria at the time of the send?