Linq Query to Filter future and past date

it should be dataTable. also in “Value to Save” field you only need to write the query and not table reference as dt_pastDates.
thus, in “Save to” type in dt_pastDates and in
“Value to Save” - DT1.AsEnumerable.Where(function(r) cdate(r(“Date of Completion”)) < DateTime.Today.Date).CopyToDataTable

1 Like