Jenni,
DayRunDate +X will return what is called a DATETIME in SQL/database talk. That means it will return a specific date AND time, and, because of the specific peculiarities of List Manager, when you set it to equal like that, the default time is 12:00 AM that day. So, for example, DayRunDate +4 would give you 4 days from today, so the 18th of March 2022 at 12:00 AM. Since, presumably that is not when your performance is actually taking place, your list returns nothing. If you choose greater than or equal to, it also uses 12:00 AM on the relevant day which is why your +7 days is working. If you choose less than or equal to, it uses a split second BEFORE midnight on the following day, so that would be the 18th of March 2022 at 11:59:59 PM.
So, when making a dynamic list for performances 4 days away, what you would want to do is use Ticket History Perf Date twice in the same list. The first one would be greater than or equal to DayRunDate +4, and the second one would be less than or equal to DayRunDate +4. Assuming you have a performance 4 days out, that would give you that list of people. Those two parameters alone would of course return patrons from ANY performances that day, and not just the one you want, but you should be able to use other elements to eliminate those results.
We do this all the time for our triggered e-mails. Let me know if that does not make sense or work.
John A. Moskal II
That worked. Thanks, John!
Does anyone know if it's possible to use relative dates in my output filter on ticketing history? I can only currently hard code in a date.