Skip to main content
Question

Deleting record in excel advance

  • Nov 25, 2024 9:04 AM UTC
  • 2 replies
  • 126 views

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

    2 replies

    Zaid Chougle
    Navigator | Tier 3
    Forum|alt.badge.img+9
    • Zaid Chougle
    • Navigator | Tier 3
    • Nov 26, 2024 11:45 AM UTC

    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 !
      • abishek22225
      • Author
      • Navigator | Tier 3
      • Nov 26, 2024 12:52 PM UTC

      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

        Terms & ConditionsAccessibility statement