Skip to main content
Question

Deleting record in excel advance

  • November 25, 2024
  • 2 replies
  • 59 views
A
Forum|alt.badge.img+5

how to delete rows with the date in excel

Actually I am in progress of deleting past 7 days record in excel sheet with date may i know how to get the date and delete past 7 days in automation anywhere when i try to delete without loop it just delete 1 record when with in the loop it just delete all the record

Zaid Chougle

2 replies

Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+17
  • Zaid Chougle
  • Navigator | Tier 3
  • November 26, 2024

how to delete rows with the date in excel

Actually I am in progress of deleting past 7 days record in excel sheet with date may i know how to get the date and delete past 7 days in automation anywhere when i try to delete without loop it just delete 1 record when with in the loop it just delete all the record

Hey ​@abishek22225 ,

You can use Datetime:Substract, pass system date, then you can compare it with the excel date. 

 

Lets Automate !
Vatsy
A
Forum|alt.badge.img+5
  • abishek22225
  • Author
  • Navigator | Tier 3
  • November 26, 2024

Thanks for the reply when i have done this all that you said but i have a problem in when it delete the 5 row the 6 row place it in 5 row so it was not deleting the row properly what should i do now

kindly help me in this

Vatsy
Terms & ConditionsCookie settingsAccessibility statement