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
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).
+15how 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
Hi
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
+15You can save the previous row data in a variable and once you delete and go to the next iteration, you can initially check for the previous row data and then the current row. This will work for the row getting shifted up.
+15Sure
Initially there will be a loop for each row in excel → At the end of the loop please save the entire row / date in a variable. In the next iteration it will check for current row and previous row as well(this is for the row getting shifted up post deletion).
Check the logic it will work.
+15
+15First → 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).
+15Another logic is what you can do is
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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
