Hallo,
I want to filter data rows where the date is older than today.
for this I assigned: dtfilter = dtTest.Select.Where(function(x) x(“Date”).ToString < DateTime.Today.ToString(“dd.MM.yyyy”))
dtfilter as system.collections.ienumerable(system.data.datarow)
no error is shown, but in debugging mode it shows no entries.
After that I need to move the data in a diffrent datatable.
Hi, it’s not a complicated process since it’s a test run.
dtTest has 2 Colums “ID” and “Date”. I then added couple of data rows.
Now I want to take all the entries out which are not from today.
for this I tried with assign action: dtfilter = dtTest.Select.Where(function(x) x(“Date”).ToString < DateTime.Today.ToString(“dd.MM.yyyy”))
And dtfilter as system.collections.ienumerable(system.data.datarow)
No error but also no result.
The last thing I tried is @Nived method:
dtfilter = dtTest.Select.Where(function(x) Cdate(x(“Date”)) < DateTime.Today.ToString(“dd.MM.yyyy”)).CopyToDataTable
dtfilter as DataTable
Hi Nived,
When I open your file it’s fine. But when I apply it to my workflow it says AsEnumerable is no member of System. Data.DataTable. I’m confused.
P.S maybe I should also mention I build the Datatable with Build Data Table activity