Edit LINQ

[Shikhar_Tandon]

Hi @fairymemay ,

Try this -

InputDT.AsEnumerable.Where(Function(x)x(“Status (1)”).ToString.ToLower.Equals(“complete”) and Cint(x(“Count”)) >= 15 and String.IsNullOrEmpty(“Chk Dup”).ToString and DateTime.ParseExact(x(“Issue Date”).ToString.Trim,“yyyyMMdd”,System.Globalization.CultureInfo.InvariantCulture).AddYears(-543)<= ApproveDate andAlso String.IsNullOrWhiteSpace(x(“Status”).ToString)).ToArray

Thanks