Unable to filter data table using date

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.

1 Like


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

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

1 Like

Use “Cdate” while filtering

1 Like

Hope this would help you resolve this

Cheers @Manoj_Gandham1