Converting String column in a DataTable to DateTime

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

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

Use above format to convert it in date format

In side for loop right?

Main (1).xaml (8.8 KB)

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

Hi all,

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

Regards
Balamurugan.S