Hello Sander, > I want to add a variable numer of months to the current date CURDATE(). > I thought it should be something like this: > select (MONTH(CURRENT_DATE)+MONTH(2)) > but i get NULL as a result. > > The purpose of this it to check which records with a experation date is > earlier or later than today+2 months later. > > Can somebody please tell me how to do this?
Would MySQL's ADD_DATE() suit? =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]