I need to Filter Negative values from Datatable , if there is no empty cell in a column Cint(x(“Amount”).ToString)<0 is working but if have empty cells the logic throw error like
“input formart not correct” . Please help to Find Solution.
My filter is
GTS_Data.AsEnumerable.Where(Function(x) (x(“Instrument”).ToString.Trim.Contains
(“FX-FORWARD”)) and (x(“Payment Date”).ToString.Trim.ToLower.Contains(Now.AddDays(1Test.xlsx (48.3 KB) ).Date.toString(“M/dd/yyyy”))) and cint(x(“Payment Amount”).ToString.Trim)<0).ToArray