Skip to main content
A
abishek22225
Navigator | Tier 3
November 25, 2024

Deleting excel row with date

  • November 25, 2024
  • 13 replies
  • 201 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

Kindly give me a flow

    Pinned Reply By Zaid Chougle

    ​@abishek22225 ,

    First → Use loop (For each row in excel advanced)

    Second → Get System Date time, then subtract it by 7 Days. 

    Third→ Use If condition( check variable date == subtracted date), delete row.

    Fourth → Use if condition (check previous row date == subtracted date), delete row.

    Fifth → Assign Current Row to a variable, example (Previous_Row).

     

    13 replies

    Show previous replies
    Zaid Chougle
    Navigator | Tier 3
    Zaid Chougle
    Navigator | Tier 3
    November 28, 2024

    ​@abishek22225 ,

    First → Use loop (For each row in excel advanced)

    Second → Get System Date time, then subtract it by 7 Days. 

    Third→ Use If condition( check variable date == subtracted date), delete row.

    Fourth → Use if condition (check previous row date == subtracted date), delete row.

    Fifth → Assign Current Row to a variable, example (Previous_Row).

     
    Lets Automate !
      Zaid Chougle
      Navigator | Tier 3
      Zaid Chougle
      Navigator | Tier 3
      November 28, 2024

      Another logic is what you can do is ​@abishek22225, you can use while loop, after the end of the while loop you can get the shifted date and that will again check the while loop, once the condition is false than it will come out of the while loop and traverse in the excel loop

       
      Lets Automate !
        A
        abishek22225Author
        Navigator | Tier 3
        November 28, 2024

        Thank you for this Answer sir now I have a logic that we can see the details of student present for example : There is birthday for student in college i need to send wish throug mail and save in another excel who has birthday if there is no birthday it shoud enter no one has birthday in that log now there are 60 students. loop was checking the 60 students and  there is birthday for one student it enter correctly in log but the 59 don’t have birthday it enter in the log that no one has birthday what should i do now?

          Terms & ConditionsAccessibility statement