I am trying to concatenate 2 attributes of different data types...
One is date (TRANS_DT), and another one is text (Customer_Name)
I am usign the following query
(TRANS_DT+Customer_Name) as key_combo
getting an error message
"Syntax error converting datetime from character string."