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)
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.