Triggered emails list question

Hi guys,

I've recently started getting to grips with Triggered Emails and putting together the lists to run them. I want to create a list of every constituent that booked to a certain show 3 days ago, with the ticket purchase acting as the trigger.

So far, I've managed to successfully pull a list of everyone who booked within 3 days using the criteria;
Ticket Production IN Ticket Production Season
Ticket Order Date >= DayRunDate -3

However when I use the Ticket Order Date criteria with a different operator to get only constituents who booked 3 days ago;
TicketOrderDate = DayRunDate -3

the count returns 0 constituents.

I thought from reading the documentation and my previous experience with Extractions and List Builder that this criteria would have given me the data I need, especially as Tessitura won't let me select any other operators such as Like or Has that may give an exact date. From checking the original list using the operator >= there are customers who booked exactly 3 days ago, I can see that there is data there, it just doesn't appear when I use the operator =. Has anyone else had this problem?

Sam

Parents
  • Try using TicketOrderDate between DayRunDate -3 and DayRunDate -3.  If you use date = X the system will add a time stamp to the end of the date and because you have no sales with the exact time stamp you are getting no results.  If you use between with the same dates it will capture all times that day.

Reply
  • Try using TicketOrderDate between DayRunDate -3 and DayRunDate -3.  If you use date = X the system will add a time stamp to the end of the date and because you have no sales with the exact time stamp you are getting no results.  If you use between with the same dates it will capture all times that day.

Children
No Data