Unable to Truncate decimal places from decimal values of a column in Datatable

[mailsmithash (Smitha)]

@J0ska

(From row In dt1.AsEnumerable
Select dt2.rows.Add(CStr(row.Item(0)).Split("."c)(0))).copytodatatable

Hi,

Thanks for the inputs the issue is resolved now …following the steps above updating the existing Datatable column values without creating new Datatable. Used Invoke Code activity to call the below code, Also referred the below link:

Datatable column update using Foreach in lambda expression is throwing an error

@mbalaji1985 Have a look on edited XAML here: mbalaji1985_II.xaml (7.7 KB) please crosscheck the formats e.g. day and month are in the right order Date conversion were finally done with: r.SetField(Of String)(“Start time”,Date.ParseExact(r(“Start time”).ToString(),“M/d/yyyy hh:mm:ss tt”, CultureInfo.InvariantCulture).ToString(“M/d/yyyy”)

DataTable.AsEnumerable().ToList().ForEach(Sub (r) r.SetField(Of String)(“Amount”, CStr(r.Item(3)).Split("."c)(0)))