Convert Date in Datatable

[Gokul001 (Gokul Balaji)]

Hi @Dmitri00007

Try this below expression

dt.AsEnumerable().ToList().ForEach(Sub(row) row(“DatefffZ”)=DateTime.ParseExact(Inputstring/ColumnName,“dd.MM.yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/yyyy”))

Have a look on the thread

How to modify / change / update or replace value as date in data table cell using LINQ?

Hi @prasath17, thanks for quick response. How to handle error? RemoteException wrapping System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> RemoteException wrapping System.ArgumentException: String was not recognized as a valid DateTime.Couldn't store <15-07-2020 14:12:12> in Date1 Column. Expected type is DateTime. ---> RemoteException wrapping System.FormatException: String was not recognized as a valid DateTime. I have invoked cod…

Regards
Gokul