How to convert a string in dd/MM/yyyy into MM/dd/yyyy hh:mm:ss in DateTime Format

[mibise2958 (Ramesh)]

Hi all , I do have column with value of date format of “dd/MM/yyyy” and I want it to covert as “MM/dd/yyyy hh:mm:ss”

your earliest attention in this regard much appreciated.

[jack.chan]

heres a solution (remember to change the file paths)
Sequence.xaml (6.1 KB)

original excel:

1. read excel
2. loop over excel, converting the dates to dd/MM/yyyy hh:mm:ss
3. write to new excel
   
   

result:

[Karuna (Karuna Devanagavi)]

@mibise2958
Try this

DateFormat.zip (12.2 KB)

Output