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
Hi Jeff,
Tessitura recomends that you use the operator Between instead of >, = or < when dealing with dates.
Criteria with date values always consider the time in addition to the date, even though the time cannot be entered in the value field. The time of 12:00 am is used by default, except when the BETWEEN operator is used in which case 12:00 am is used for the first date and 11:59 pm is used for the second date.
Unless you are working with this in SQL, You should use between.
Hope this is helpful
Susan