i was a bit confused by your post because you say
older than the previous Friday must be deleted
then you say
today is Friday, 5/31/13 so I need to delete all rows with a date greater than Friday, 5/24/13.
a date greater than means more current, but older means further in the past
either way just change the
line from < to > to suit your needs
also your example only went to 5/23/13 so there were no dates more recent anyway (it deletes no rows >, also it deletes all lines if you say <) I extended the dates out so i could see if it worked and the code works either direction
Bookmarks