Filter the data within excel sheet by passing start date and end date

[Samsanditha]

i have attached input excel sheet…the requirement is to sort the values within excel based on date values based on start date and end date…used filter table but didn’t help…kindly help

Thanks

[baisilgee (Baisil Geevarghese)]

hi @Samsanditha,

Please go through it, you might get the solution.

Sorting Date

hey, i am having somewhat similar task. I hope you can help me. I am having a column with dates from year 2000 to 2019. I want to get only the date with year 2019 and all the columns along with that. I tried filter datatable activity but no luck. Not recognising dates.Column was in general format initially and I changed to date format manually in excel , no luck Then I came across the select activity and tried I am havinf trouble sorting it out. How to achieve this?

Sort data in Excel

Hi @Sob I am using UiPath 2018.1.1 I didn’t find the sort datatable activity For your Reference [image] Regards JothyPrasanth M

Regards,
BaisilGee

[Lahiru.Fernando]

Hi @Samsanditha

@Samsanditha

used filter table but didn’t help…kindly help

If you want to sort the data table, the filter data table activity is not the one you should use. You have to use the Sort Data table activity to sort the data in the required order

[Samsanditha]

Sorry my bad i need to filter the data based on date.

Thank you

[Lahiru.Fernando]

no worries…
So when you use the filter data table activity, what happens? does it throw any error?

[Samsanditha]

i am passing the date value to be filtered as"16-08-2019"…but in the output excel sheet it is not updating the changes.

Thanks

[Lahiru.Fernando]

Can I see a screenshot of the filter data table activity to see how you have done it?

[Samsanditha]

…Date column also has timestamp is it not working because of that???

Thanks

[kalyanDev]

once you filtered with the date …the output of the filter data table you are writing into excel or not ?

[Samsanditha]

it is not filtering the date which i specified…its writing all the values

[Lahiru.Fernando]

@Samsanditha

in the screenhot, Row Filtering Mode you have set it to Remove. So basically what happens here is, it will look for that date and remove it from the data table leaving rest of the dates in the data table. That’s why you are seeing all the values. I suppose for your requirement this should be set to Keep, not Remove

[Samsanditha]

i even tried using keep filter option…it didn’t work

Thanks

[Lahiru.Fernando]

I assume the format shown in the excel is not the actual format the data is in. Select one date in the excel and see the excel formula bar for the exact format of the date. So you have to use the format shown in the formula bar

Try and let me know whether it works

[Samsanditha]

i have attached the zip file if time persist just have a look over it …copied exact date format but still not able to filter

[Natarajan_Manojkumar]

Do you find solution for this? I have exact problem.

[prasath17 (Guru)]

@Natarajan_Manojkumar

Do you find solution for this? I have exact problem.

Please open up a new forum post and share your issue with some sample data…we will take a look and assist.