Filter Datatable contains datetime

[inyourgravity]

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 sheet.

[kaderms (Kader)]

You can use the excel filter (in excel application) to get this done. Then read the resulting sheet as a dataTable if needed.
Check this out. Kind of a similar scenario. Have mentioned shortcuts for working with filters.

How to distinct the excel

Okay… I am gonna help you do this with just excel shortcuts. You can use Excel Application Scope to open excel Select Range Sheet1 - A1 to move to the header Send hotkey Ctrl + Shift + L - shortcuts for applying filter (make sure filter was not applied earlier) Select Range Sheet1 - B1 to move to the Column B header Send hotkey Alt + Down to open the filter dropdown Type Into “FM7171[k(enter)]” into the search box Send hotkey Ctrl + a to select filtered text Send hotkey Ctrl + c to co…

[Mateus_Cruz]

The syntax is a bit different from what you used: Select("date >= #" + from_date + "# AND date <= #" + to_date + "#") (source)

Please check this for reference: FilterDateTimeInDataTable.zip (9.2 KB)

[inyourgravity]

I also tried converting the datetime column into string and then check if the column’s strings contains my datetime in short date format, works too.

datatable = (From p In Datatable.Select() Where Convert.ToString((p.Item(“Datetime Column Name”))).Contains(DateTime.toshortdatestring) Select p).ToArray.CopyToDataTable