Applying Date filters in excel data

[lokesh888 (lokesh)]

I got some excel data that contains date column and i need to filter the current month information from the whole data, and the date format in excel is… yyyy-mm-dd.
Can anyone help me regarding this?

[Palaniyappan (Palaniyappan P)]

Hope this would help you

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 @lokesh888