Today, im trying to filter by date In Excel in the same sheet Using this LinQ:
(From z In DT1 Where Not String.IsNullOrEmpty(z(18).ToString) And Convert.ToDateTime(z(18).ToString) > Date.Now.AddDays(-41)Select z).CopyToDataTable
The date is in the column 19 BUt is returning this message:
The string was not recognized as a valid DateTime. There is an unknown word starting at index 0
How can i improve this LinQ??