Fredrik Lundh wrote: > > what do you expect d_new to be after the operation ? if the answer > is date(2006,3,17), what's date(2006,1,31) plus one month? February 31st, of course: http://sql-info.de/mysql/gotchas.html#1_14 ;-) Paul