Filter DT with date (Excel is not format of datetime)

[ercanebiler (Ercan)]

Hi,

There’s a column which contains values “23.01.2020”. These values are not format of datetime.

I have last day of previous month(“31.12.2019”)
I have first day of previous month(“01.12.2019”)

I want to filter rows between these days. What method is the effective one for that case?

Any help appreciated.
Thanks

[Pradeep_Shiv]

@ercanebiler

(“31.12.2019”)
I have first day of previous month(“01.12.2019”)

so you have dates in between
(“01.12.2019”) and (“31.12.2019”)
and you need those dates??

[Pradeep_Shiv]

Can you provide me your SampleExcel
Cheers @ercanebiler

[Palaniyappan (Forum Leader)]

Hi
Kindly have a view on this thread

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