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????
@AshCCC another way of doing this with the Multi-Filed formula
Hi,@AshCCC
you can use DateTimeParse function in Multi-Field Formula tool.
@AshCCC Try a Transpose tool to bring the 5+ columns vertically.
thx!! let me try again!
wow that's awesome as well, let me have a try anyway, thx!!
Huge thx to you !!!!