Filter data table by date issue

Help Studio
, ,
1

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

Extracted table from xls

image

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

image

output table(filtered table)

image

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

2

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

3

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

4

@sekhar_talasila
This thread will be helpful for you.

Filter data table activities how to filter the date

5

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

Thanks

Happy Automation!

6

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