Filter data table activities how to filter the date

[VolkerHuang (珂 黄)]

• How to filter the date, as shown in the figure cannot be filtered

[Palaniyappan (Palaniyappan P)]

Kindly have a view on this thread
because with filter datatable activity we will be able to filter the column with datetime only if that column is of type datetime
so we can do that with SELECT method

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

[VolkerHuang (珂 黄)]

@Palaniyappan Many thanks

[Palaniyappan (Palaniyappan P)]

Cheers @VolkerHuang