Delete row from datatable based on date math

I have a spreadsheet (example provided) where each row has a date. I need to remove rows where the date is less than 3 years old. I am not familiar with how to accomplish this. Tell me if there is more information needed.

Consolidated.xlsx (2.1 MB)

There should be a lot many ways to do it. Here one.

You can use Filter Data Table activity with the condition like
ColumnName > DateAdd(DateInterval.Year, -3, Today)

You can write the resulting datatable into another sheet or the same sheet using Write Range activity.

https://activities.uipath.com/docs/filter-data-table

1 Like