Excel Date data remove

Help Activities
,
1

Hi ,

One excel file.One date column here. Remove the entire row 10 yers back.
Like
15-JUNE-2010-------Remove
15-JUNE-2016-------Keep

2

you can use filter datatable, remove the line containing the data you want to remove

3

Hi @AsadPathan2665

Try this-

  1. Calculate the date that is 10 years ago using the DateTime.Now.AddYears(-10) method.
  2. Compare the date value with the calculated date using the DateTime.Compare method. If the date is less than the calculated date, it means it is 10 years or more in the past.
  3. If the date meets the condition, use the “Remove Data Row” activity to remove the current row from the DataTable.
  4. After iterating through all the rows, use the “Write Range” activity to write the modified DataTable back to the Excel file.

Thanks!!

4

@AsadPathan2665

Filter excel activity…with advanced filter less than Now.ToString("MM/dd/yyyy 00:00:00")

Then use delete rows activity and select visible rows

Cheers