Filter Data Table with Date Range

[prititit]

How to Filter data table with date range.Like for example 1 week data. Using this date format

ex. Aug 20, 2020

[Latika10011740 (Latika V N Durga Bhavani)]

Hi @prititit

Please check this post,

Filter Data table having Date column

Heloo, Thanks for ur response. Can it be done with filter wizard… as i need to filter other column too. But i am stuck in date column. Its not taking properly Thanks

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…

Mark as solution if it works
Thanks
Latika