I’m working on an excel file, i have managed to get the datetime column to be copied out onto new column. But i want the column to be separated for time and date.
Lets say if first column should contain the date only and the second column only store the time only.
i try to use split on the first column it is not working. But when i was using split on the second column it works well. Can anyone tell me what are i’m missing out here.
Attached are the output of the first column and on the second picture is the original format of the data in that row.
i do notice that there is two white spaces before the time variable. If that is what causing the error how do i overcome this.
Current datatype of this row column are in datetime format. and if i do get a solution on this i want to retain the datatype but as for the date format could be as dd-MM-yyyy in datetime format not as a string.
Please help me. Thank you in advance.