How to Use Select Method

[PrankurJoshi]

Hi @vickydas

See these

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…

Filter Date in Date Table?

I have Data table name resultDt The datas are shown below [image] My requirement is to get the last 3 months count of the name. For example NewDate = today.Addmonths(-3) it will give 03-04-17.Now the NewDate is Compare to DataTable resultDt.After the NewDate I have 3 records So it Should return Count of Rows as “3”. Can some one help me to achieve this. Thanks in advance (Jothyprasanth M)

Thanks,
Prankur