Delete row from datatable based on date math


#1

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)


#2

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.