Filter year/Date from excel

I need to filter data start from 2020 in column planned start,Can i use filter data table activity in this case?Untitled

1 Like

Yes you can

1 Like

Why i cant use contains? “Planned start” Contains “2020”.Is that wrong?

help please

are you using it in filter datatable activity?

yes i use in filter datatable

1 Like

Then it will work…

yes it work but not accurate

accurate in terms of???

I need a count from “phase” = deployment ,“planned start”="2020"

it state zero

you can use Datatable.Select method to query -
like below -

dt1.Select(“phase = ‘deployment’ and planned start like ‘%2020%’”)


@kuih_sedap Can you try this Linq :
DT1.AsEnumerable().Where(Function(row) row(“Phase”).ToString.Trim.Tolower.Equals(“deployment”) and row(“Planned Start”).ToString.Trim.Tolower.Contains(“2020”)).CopyToDataTable


Please check your input excel file, if it actually has “Planned Start” to be containing “2020” and
“Phase” to be equal to be “Development”…

I never saw the above combination in your screenshots of excel file.

Check if you are dealing with the correct excel…

As i checked with Filter data table… I was able to filter my dummy data using the conditions…

Thanks and Regards,

The file is right,I’ve filtered manually and the data is right.

But it still state zero

Can you share your excel?

I will create a flow and share with you instantly.


I guess there was something wrong with the excel (atleast in my case)…

When I try to open the excel file manually, i get below error:-

Also, When I try to open the excel file using the UiPath activity(Read Range - Workbook), I get the below error:-

Kindly help me understand, what exactly is happening here, in my case.

Thanks and Regards,

@kuih_sedap Can you try this and Check (65.1 KB) is and Check :sweat_smile:


How can i select multiptle items from column Phase?

@kuih_sedap you’ll need to modify the Linq Query a bit, Tell me the condition