Unable to filter datatable using date filter

[sureshj (suresh_hserus)]

@Parikshith_V
Please find the below which has a solution,

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…

How to Filter Excel Data by Today's Date

I need help filtering data that’s exported to excel from an application by today’s date. Can someone help me with the proper VB I can use in the FilterOptions field of a Filter Table activity? Or if you know of a better way to filter the data coming in by today’s date, please let me know. Thank you!

Hope this will help you.

Thanks,
Suresh J