I am not sure of the function of your application, but is it worth having several tables that are date related and then just drop the tables that are relevent to the dates that need to be purged? i.e. have a script that finds all tables "tablenameddmmyyyy" and autocreate views for use of reading data. Insert records in the table"tablenametoday" (today is formatted same (ddmmyy)) . This may help, depending on what type of application you have and how much control you want to manage/maintain.
** What you see, Depends on what you Thought, Before, You looked! **