Change format date excel

[Parvathy (PS Parvathy)]

Hi @Stef_99

=> Read Range Workbook.
Output → dt

=> For Each Row in DataTable dt
Assign:
CurrentRow("Planned Start") = DateTime.ParseExact(CurrentRow("Planned Start").ToString,{"dd/MM/yyyy HH:mm:ss","d/M/yyyy HH:mm"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd/MM/yyyy HH:mm:ss")

=> Write Range Workbook dt back to excel. Enable Add Headers option.

Output:

Regards