Unable to filter data table using date

[Manoj_Gandham1 (Manoj Gandham)]

i am having one data table in which there are 3 rows, (Column name=“Invoice Date”)
row 1 contains =26-05-2018
row 2 contains=30-06-2018
row 3 contains=06-02-2018
while filtering data table first 2 rows i am able to filter using date values, but for the 3rd one i am unable to filter the same, because of different format.
so i used msgbox to check what values are coming, then i found for 3rd row it is reading as “06-02-2018 00:00:00”
and after that i have tried to filter with different ways by using datatype as a “string” “int” “datetime”.
but none of them are working,
can any one suggest any option.

[lakshman (Ganta lakshman)]

@Manoj_Gandham1

@Manoj_Gandham1

06-02-2018 00:00:00

Split the date based on space as delimiter and take first value for your comparison.

[Manoj_Gandham1 (Manoj Gandham)]

thanks bro,
even i have tried by using split method but it didn’t work for me.

[mhk15 (mehak)]

@Manoj_Gandham1

for the 3rd one i am unable to filter the same, because of different format.

Use “Cdate” while filtering

[Palaniyappan (Forum Leader)]

Hi
Hope this would help you resolve this

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