Linq how to exclude OrderID from a other Datatable

Help Studio
,
2

Hi @raiko.m ,

When comparing numbers, we have to convert them to integers/double first.

From d In dtInput.AsEnumerable
Where CInt(d("Rate").ToString) <= 47
Where Convert.ToDateTime(d("Date").ToString) <= DateTime.Today
Select d).CopyToDataTable()

Is this producing the result that you were looking for?

Kind Regards,
Ashwin A.K