Hello Frank,
Thank you for your reply.

I did as you asked, here is the query:

delete from zen_email_archive where date_sent <= '20101307'

Just wondering, shouldn't the date have shown up as 20100713?

Hope you can solve this.

Best Regards,