I am in the process of building an output set for our Triggered Email list, and I have run into a wall trying to build an element to pull the Performance Time into the set.
Has anyone found a way to build that in TR_QUERY_ELEMENT?
Any tips and tricks are welcome!
Hey Kira, I can't find your email on your profile. Drop me a line and I'll send you the details: d.hall@festival.melbourne
As a side note, our view just looks at the perf_dt and does some SQL trickery to pull out the time in our preferred format: Ltrim(RIGHT(CONVERT(VARCHAR(20), perf_dt, 100), 7))