Convert String to Date_entire column

Hi
How to Convert entire column from string to date

Is that a column in a datatable or in excel?

Coulmn in datatable

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

Throwing syntax error

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

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

Hi @KarthikBallary,

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

Regards
Balamurugan.S