Hi All,
I'm having a strange behavior while trying to make Dynamic List Manager lists to fetch ticket holders for Tomorrow's performance. It seems to me that if I use an "=" operator, and a relative date, the criterion is selecting down to the minute of the run date for a Performance date in Ticket History, as this list never selects any constituents. So instead I am forced to do a between by using successive ">=" and "<=" operators. However in this case the resulting criterion seems to be only specify to the day, meaning that for a between of +1 and +2 I will have selected tomorrow's and the following date's ticket holders.
So is it not the case that the Following criteria should select (as least on most of the clock) only tomorrow's ticket holders?
Ticket History Perf Date >= RunDateDay +1
Ticket History Perf Date <= RunDateDay +2
Thanks for your eyes, everyone!
-Jeff
Susan is correct when it comes to using fixed dates, but with relative dates you can’t use the BETWEEN operator. For relative dates what Jeff is doing is correct, i.e. add the same criterion to the set twice, once with <= as the operator and once with >= as the operator.
Jeff, even though you don’t specify the time, the system should automatically add 12:00:00 AM (the beginning of the day) to the value for criterion with >= as the operator, and 11:59:59 PM to the value calculated for the criterion with <=. Based on that, to get the result you are looking for you would enter RunDateDay +1 as the value for BOTH criterion, and the calculated date and time range will be from the beginning of tomorrow to the end of tomorrow.
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
Thanks for the clarification, Kevin. I found the varying behaviors when using different operators a little bit mystifying for a while there. Much appreciated!