I need to pull a list of patrons who purchased their tickets within a week of their performance date (i.e. tickets for a performance on 12/1 that were bought between 11/24-12/1). However, I need to do this for 3 months worth of shows (over 100 performances). Without running a report or a list for each performance individually (who has that kind of time?), how can I set something up that will pull relative data- order date is <7 days before performance date for the run of a production? Any advice or procedure is greatly appreciated.
It will not automatically email, but it may save you time because you can have as many shows as part of the recipe and it will give the relative dates from each performance.