Filter data table by date issue

Hi Team ,
am unable to filter the below table data by date

Extracted table from xls


when am filtering through filter data table am getting only columns names in output table


output table(filtered table)


Kindly suggest me how to filter by date condition for above case?

@sekhar_talasila you can filter like this one. because date is string and you can’t put less than, greater than operator

Oh okay. May i know exact operator or value to filter date ?
missing in your last message.

This thread will be helpful for you.

Filter data table activities how to filter the date

Hi @sekhar_talasila

You can filter this datatable using linq Expression:
DT.AsEnumerable.Where(Function(x) CDate(x(“Date”).ToString).Date<CDate(GivenDate)).CopyToDatatable

If CDate function isn’t working then use this
DT.AsEnumerable.Where(Function(x) Datetime.ParseExact(x(“Date”).ToString,“dd-MM-yyyy”,Globalization.CultureInfo.InvariantCulture)<Datetime.ParseExact(GivenDate,“dd-MM-yyyy”,Globalization.CultureInfo.InvariantCulture)).CopyToDatatable


Happy Automation!

You have to convert the column to a datetime column, then you can sort and filter properly.