Converting String column in a DataTable to DateTime

[Rajat_16 (Rajat Pandit)]

Hey everyone, I am stuck in a scenario. I have a DataTable. There’s only one column in it. That column contains Date which is in a form of string. Now I wanted to convert this whole row to Date format and Store it in a List so that I can compare this list of Date to the present date. I am not able to convert the string row to Date

[Mihir_Mapara]

Convert.ToDateTime(row.Item(“DatatableColumnName”).ToString).ToString(“dd/MM/yyyy”)

Use above format to convert it in date format

[Rajat_16 (Rajat Pandit)]

@Mihir_Mapara

Convert.ToDateTime(row.Item(“DatatableColumnName”).ToString).ToString(“dd/MM/yyyy”)

In side for loop right?

[Rajat_16 (Rajat Pandit)]

Main (1).xaml (8.8 KB)

Here is the file. It’s throwing error when the date is in double digit

[balupad14 (Balamurugan)]

Hi all,

In the below thread explain you that how to conver the string or object data column to datetime.

UiPath Marketplace - BalaReva Easy Data Table Activities

Dear all, I have developed a new activity called “DateTime ParseTo Datatable”. Convert the object/string data type to dateTime datatype in Data. And also has the solution Solution to manage the excel DateTime in DataTable. [image] Sample :DateConversion.zip (35.5 KB) [UiPath convert column datatype to datetime in DataTable] Thank you Balamurugan.S

Regards
Balamurugan.S