LINQ Query Troubleshooting

Help Studio
, ,
9

Hi,

The following might help you.

image
image450×612 13.6 KB 

dtFrstChkSuccessRecords.AsEnumerable.ToList.ForEach(
Sub(r)
    Dim d As DateTime
    If DateTime.TryParseExact(r("Column2").ToString,"d.M.yyyy",System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None,d)
        r("Column2")=d.ToString("MM/dd/yyyy")
    End If
End Sub
)

Sample20221125-7.zip (3.0 KB)

Regards,