Wordfly - Date Formatting

European Museum of the Year 2013 – Riverside Museum - Winner

Edge Awards 2014 – Award for Innovative Library and Information Projects (Physical Category) – Macmillan @ Glasgow Libraries – Winner.

Volunteurope 2014 – Active Citizens of Europe Award (NGO Category) – Macmillan @ Glasgow Libraries – Winner.

Scottish Event Awards 2014 – Best Marketing Strategy – Glasgow Life for UCI Juniors Track World Championships – Winner.

Marketing Society Star Awards 2014 - Silver Star Award – Glasgow Life – Glasgow World Cup Gymnastics 2013.

Visit Scotland Visitor Attraction – All museums run by Glasgow Life now graded 4-5 stars.

Glasgow - UK Council of the Year 2015

---------------------------------------------------------------------

Disclaimer:

Glasgow Life and the sub-brands mentioned below are operating name(s) of Culture and Sport Glasgow ("CSG"). CSG is a company limited by guarantee, registered in Scotland with company number SC313851 and having its registered office at 220 High Street, Glasgow, G4 0QW. CSG is registered as a charity with the office of the Scottish Charity Regulator (No SC037844). It operates and carries out its activities under the name Glasgow Life and/or the sub-brands Glasgow Arts, Glasgow Communities, Glasgow Concert Halls, Glasgow Events, Glasgow Libraries, Glasgow Museums, Glasgow Sport, Young Glasgow and their related branding.

This message is intended only for use of the addressee. If this message was sent to you in error, please notify the sender and delete this message. Glasgow Life cannot accept responsibility for viruses, so please scan attachments. Views expressed in this message do not necessarily reflect those of Glasgow Life who will not necessarily be bound by its contents.

Sorry, I've realised need to be more clear when I mean "it's coming out American style!"

The output set has a field named "Performance Date" which I built using the local ticket history view.  The date format is dd/mm/yyyy hh:mm:ss .  When it's pulled through to Wordfly, it Americanises it so that, for example, the 6 March 2016 become 3 June 2016.  

Hi Jo

Do you mean the triggered e-mails via Wordfly?  It was actually quite easy in the end (apart from the performance date).  We started them on Friday night however didn't notice the incorrect date format - loads of calls on Saturday.  The instructions are on the Wordfly site:

https://support.wordfly.com/hc/en-us/articles/204768554-How-do-I-set-up-and-test-a-Tessitura-Triggered-Campaign-

The post show proved a little more complicated than expected but another organisation gave me the SQL query they used for their post show e-mails.  I didn't need to amend the query at all.  I can e-mail this to you if you are interested.

Best

Lee-Anne

Have you set up a custom data Field in WordFly to put the date in the format you want or have you done that and it is still changing it?

Caryl

Hi Caryl

I have set-up a custom field and tried most date formats as I did think it was the format.  Nothing works. I have just this moment tried the field without any formatting, it comes through as yyyy/dd/mm thh:mm:ss.  So while it looks it in the UK format before it leaves Tessitura it appears to be converted somewhere.

Thanks

Lee-Anne

Is the date converted to UK format in the SQL using the convert function e.g. CONVERT(VARCHAR(11),GETDATE(),103) if so and it isn't working I'd open a support ticket with WordFly.

Caryl

Sorry for being a bit dim but whereabouts it in the SQL?  This is my first time using Wordfly so am a bit clueless to all this. 

Edit:  I've worked out where the SQL should go.  Being not only a Wordfly novice but an Output set novice is not helping my cause.  It's not working.

Thanks for your help Caryl.  

I solved my problem by changing the custom data field in Wordfly to a text field instead of date.