How to transform the DateTime format for multi-column

[AshCCC]

I'm trying to transform the String to DateTime Value, but seemed DateTime tool can do for one single column each time, how to do  for 5+ columns in one go????

[flying008]

Hi,@AshCCC 

you can use DateTimeParse function in Multi-Field Formula tool.

[Qiu]

@AshCCC 
Try a Transpose tool to bring the 5+ columns vertically.

[binuacs · Accepted solution]

@AshCCC another way of doing this with the Multi-Filed formula

[AshCCC]

thx!! let me try again!

[AshCCC]

wow that's awesome as well, let me have a try anyway, thx!!

[AshCCC]

Huge thx to you !!!!