Unable to use Date&Time column in String Manipulation (Multi Column) node

[AndrewDevlin]

I am unable to pass a Date&Time variable through the String Manipulation Multi Column node. Even when I exclude the Date&Time columns from processing, I get the error:

Execute failed: Invalid type identifier for variable in line 1: n

An old thread on this topic was closed here: String Manipulation (Multi Column): Does not handle date&time columns as $$CURRENTCOLUMN$$

[ScottF]

Hi @AndrewDevlin -

I looked up the ticket mentioned in the previous thread. Unfortunately there is nothing new to report - the node still doesn’t support datetime, collections, and other variable types.

I have added a +1 from you on the ticket. Sorry for the trouble.

[AndrewDevlin]

Thanks for the quick reply.

I was able to get around the error by adding one String column to the exclude with the Date&Time column. See attached.

[ScottF]

Ah, thanks for the clarification, I misunderstood your original problem. Glad you found a workaround.