Merge Two Columns In-Database

[Fasttrack76]

Hiya, 

First post so be gentle!  New to Alteryx and think its brilliant,

I'm struggling with creating something simple, I need to merge two columns of a name and a date, I use the Formula-In DB as follows:

[Name] + '-' + [Date] 

It doesn't work in In Database, but if I take the data out using Data stream out, and the use the same formula, it does work?

It takes longer to run out of the database (obviously) so would like to keep the flow all in, any idea why it will work in one and not the other (Ive also tried converting the date to a string prior to joining, but that still doesn't work.

Thanks

FST76

[Qiu]

@Fasttrack76 

Most likely it is a Data Type issue in DB. As suggested by below, better use  a CAST/CONVERT function for converting with legal syntax by your DB.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Formula-In-DB-Tool/td-p/306850