Hi Team Facing issue on below query
dtFrstChkSuccessRecords.AsEnumerable.Where(Function(x) x.Item(If((“Column Name”).Contains(“”),(“Column Name”),If((“Column Name”).Contains(dd.MM.yyyy),Datetime.ParseExact((“Column Name”),“dd.MM.yyyy”,System.Globalization.CultureInfo.InvariantCulture).Tostring(“MM/dd/yyyy”))).CopyToDataTable
Error giving as expectecd “)”
First, inner If doesn’t have 3rd argument.
Second, does x.item() returns boolean? If not, should add condition.
Third, it seems variable is missing in front of (“Column Name”) Is it good?
i want that when cloumn is blank than it should give blank value in same column,but if it is date then it shall convert date in required format in same column
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
)