How to convert part of data scaped column as Date variable and check if its earlier or later than specific date

Help
,
1

I’ve got Data table which was created using “Data Scrap” mechanism and im trying to keep Data which is older than “2018-01-01”
Ive tried:
A)
image
0 rows
B)
image
(error:column type is not supported)

2

@zbigniew.lukowski
Use lineq query

Suppose Datatable is DT1
Array of datarow dtr= (From r in DT1.Asenumerable.where(function(x) Convert.todatetime(x(“Date”))) < Convert.todatetime(“2018-01-01”) ) select r).toarray

if dtr.count>0
dtr.copytodatatable

Regards
Shanmukh

2 Likes