Convert String to Date_entire column

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.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)

1 Like

Hi @KarthikBallary,

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


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.