InputDT.AsEnumerable.Where(Function(x)x(“สถานะ”).ToString.ToLower.Equals(“นำจ่ายสำเร็จ”) And CInt(x(“จำนวนวัน”).Tostring) >= 15 And x(“APSTS1”).ToString <> "FLFL" And DateTime.ParseExact(x(“Issue Date”).ToString.Trim,“yyyyMMdd”,System.Globalization.CultureInfo.InvariantCulture).AddYears(-543)<= ApproveDate AndAlso String.IsNullOrWhiteSpace(x(“Status”).ToString) And String.IsNullOrEmpty(x(“Chk Dup”).ToString.Trim)).ToArray
But some row in column จำนวนวัน as blank —> So it can’t convert to int —> error as below.