Hey everyone,
I am trying to change the date input from csv file to another format that I want to use it for sorting.
The input of csv file:
Input=
'2019-01-25 17:00:17'
'2019-01-25 17:26:59'
'2019-01-25 17:39:31'
'2019-01-31 17:15:47'
-Output=datetime(Input,'InputFormat','yyyy-MM-dd HH:mm:ss');
Output:
'25-Jan-2019 17:00:17'
'25-Jan-2019 17:26:59'
'25-Jan-2019 17:39:31'
'31-Jan-2019 17:15:47'
However, I want the output 01-25-2019 HH:mm:ss
What is the best way to do that?
Best Answer