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
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