Next Concert Date

You could probably try something like min(perf_dt) from lvs_tkt_hist where perf_dt>getdate(). But replace lvs_tkt_hist with whatever you usually reference for your local ticket history. Depending on what you load into your local ticket history you might need to filter on perf type to be sure you're actually only getting concerts, but if you're already doing most recent concert or first concert you probably have that covered.

Thank you, Amanda.   That works perfectly.   I know some people in our Development department who will be very happy and more efficient at stalking our customers at concerts!

Jan

I have just been asked to set up an Output criteria to show what a customer's next concert date is.  I know how to set up most recent, first concert; highest or lowest amount.   But I don't have a clue how to set up next ticket date.   Does anyone have a suggestion?

Jan LaRocque

Houston Symphony



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!