Forum Discussion
Formatting date and time
Hey all, I need help formatting date and time columns. In my source, the date and time are displayed as follows: The goal is to format the date and time correctly without performing var...
OK, for the times we could 'split column by position' (by 6 chars as far right as possible) then Text.PadStart( to 6 chars using "0") and then change datatype to Time. I don't know if that's any quicker than the steps you have but it should work.
These are exactly the steps I have made.
Isn't there any quicker solution?