Ill try this
mikaelronstrom.blogspot.com/2006 … 25345.html
EDIT
Yes, this is a good way to partition for historical data. You could partition by week, and end up with 19+ years with this setup. Remember that there is a maximum of 1024 partitions per table