How can I sort in ascending order my excel by column that contains dates

[THIRU_NANI (NaNi)]

Hi!

Have a view on this:

Sort Excel By Latest Date

Hi, I have a problem in sorting a date format inside an excel. I have tried using Sort Data Table activity and the result doesn’t work as expected. I would like to remove rows that contains a duplicate ID with the oldest date. Hence, I tried to sort the date first into a latest date and use remove duplicate rows activity (still not sure if this works). Original Format as below: [image] Result after use Sort DataTable activity: [image] I have tried using other ways that I found in the foru…

Regards,
NaNi