Convert String to Date_entire column

[KarthikBallary]

Hi
How to Convert entire column from string to date

[SenzoD (Senzo Dlomo)]

Is that a column in a datatable or in excel?

[KarthikBallary]

Coulmn in datatable

[Priyanka_Ramesh]

1. Clone the Datatable dt2 = dt1.clone
2. Invoke Code :
   dt2.Load(dt1.CreateDataReader,System.Data.LoadOption.OverwriteChanges)
   dt2.Columns(“Exc.Rate”).DataType = “Date”

[KarthikBallary]

Throwing syntax error

[KarthikBallary]

Error:Bc30311: Value of type string cannot be converted to type

[Priyanka_Ramesh]

Datatype Change(string to Dte).xaml (7.3 KB)

[balupad14 (Balamurugan)]

Hi @KarthikBallary,

you can use the below activity to convert the entire column from string to date.

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