Change format date excel

[Stef_99 (Stef)]

Dear all,

I want to change format date to dd/mm/yyyy HH:MM:SS in column Planned Start

Please guide me for solve it.

Thank you

[Jithesh_R (Jithesh Karkera)]

@Stef_99 ,
From which format you want to change to dd/MM/yyyy HH:MM:SS format?

Regards,

[Parvathy (PS Parvathy)]

Hi @Stef_99

Try this:
CurrentRow("Planned Start") = DateTime.ParseExact(CurrentRow("Planned Start").ToString,{"MM/dd/yyyy HH:mm:ss","M/d/yyyy HH:mm"},System.Globalization.DateTimeStyles.None).ToString("dd/MM/yyyy HH:mm:ss")

Hope it helps!!

[Stef_99 (Stef)]

@Jithesh_R In column Planned Start some row have format dd/mm/yyyy HH:MM:SS and some row have format d/m/yyyy HH:MM

[Stef_99 (Stef)]

@Parvathy use loop by row right?

If I want to convert all row in column (except header) and write in same row

Please guide me for solve it.

[Yoichi]

Hi,

How about FormatCells activity?

https://docs.uipath.com/activities/other/latest/productivity/format-range-x

Regards,

[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.DateTimeStyles.None).ToString("dd/MM/yyyy HH:mm:ss")

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

In the mean while share the excel, I will help you with flow.

Regards

[AJ_Ask]

Hi @Stef_99

[Stef_99 (Stef)]

@AJ_Ask @Yoichi I follow your suggest.
But not change format.

File excel as attached.

input.xlsx (11.4 KB)

[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

[Yoichi]

Hi,

It seems already set as Text. So it’s necessary to re-input data as DateTime as the following.

Regards,

[Stef_99 (Stef)]

@Yoichi Can don’t fix F17 (don’t fix row) because sometime have row and not row 17?

[Stef_99 (Stef)]

@Parvathy Why output have same data not change format.
But after run If I click in cell and enter format have change.

Can you guide me for solve it.

[Parvathy (PS Parvathy)]

Hi @Stef_99

Output:

It is changing check the last row once.

Regards

[Stef_99 (Stef)]

@Parvathy I got your point.

But I run code follow your suggest but not change.
But It I click in cell and click enter it change format.

[Parvathy (PS Parvathy)]

Hi @Stef_99

Can you share your flow once.

Regards

[Stef_99 (Stef)]

@Parvathy Now I found cause.

Thank you for your support.