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

[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