I am trying to filter an extracted data table with date condition. Please help

[ashok.p (Ashok)]

unable to filter datatable with this condition
Date lesser than 1st of December 2019’

Please help

[Palaniyappan (Palaniyappan P)]

Kindly have a view on this

Filter Datatable contains datetime

Hi, I have an excel sheet where Robot Start Date column is in General format. Its supposed to contains values in datetime format MM/dd/yyyy HH:mm:ss I would like to filter the datatable to create a second datatable for rows which have the same date MM/dd/yyyy I’ve tried Dt.Select(“[Robot Start Date] LIKE ‘%MM/dd/yyyy%’”).copytodatatable and it says cannot perform operand LIKE on system.string and system.datetime I cannot use filter datatable activity because it is not a table in the Excel sh…

Cheers @ashok.p

[AshwinS2 (Ashwin S)]

Hi @ashok.p

Try this

How to Use Select Method

So i have scraped Invoice from Acme Website and now i want to use Select(Filter) to get the invoice of data Greater than 7-1-2018 so how do i use select to only get the above given condition Thanks in Advance

Thanks
Ashwin S