Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. <script runat="server">
  2. Platform.Load("core","1");
  3.  
  4. var deLogDev = DataExtension.Init("XXX-EXTERNAL-KEY-1-XXXXXX");
  5. var deBookings = DataExtension.Init("XXX-EXTERNAL-KEY-2-XXXXXX");
  6. var today = new Date();
  7. var thirtyDaysAgo = new Date();
  8. thirtyDaysAgo.setDate(today.getDate() - 30);
  9.  
  10. try
  11. {
  12. var filter = {Property:"LastDepartureDateTime", SimpleOperator:"greaterThan", thirtyDaysAgo };
  13. var data = deBookings.Rows.Retrieve(filter);
  14. for (var i=0; i < data.length; i++) {
  15. var result = deBookings.Rows.Remove(["LastDepartureDateTime"], [data[i].LastDepartureDateTime]);
  16. }
  17. var rowCount = data.length;
  18. deLogDev.Rows.Add({Message:Stringify(rowCount) + " items removed from this DE.",Location:"Remove Old Bookings Script",Date:Now()});
  19. }
  20. catch(ex)
  21. {
  22. deLogDev.Rows.Add({Message:Stringify(ex),Location:"Remove Old Bookings Script",Date:Now()});
  23. }
  24. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement