Hi Elke and others, after testing with my own solution (you are totally right about the first day of a month) I saw dates like 2007-01-00, what is of course more than wrong. So I used your subdate solution (adddate works also :) which is a lot better than mine ;), right the day you wrote back. But I replied to your personal email adress not the list, because I saw your answer just after sending my own mail, and was too fast with the reply. Perhaps because of this the spam-filter filtered me. But again big thanks to you, because your submission helped me a lot :) The last month was a little bit horrible in such small mistakes, there are just too much things in my head sometimes.
Nevertheless, I wish you and everybody a healthy new year! Best wishes and again thanks (I promise to do better in the future) Frank -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
