RobNYC Posted February 6, 2008 Share Posted February 6, 2008 I have a table called clients. In the table I have two date fields date and date2. I want date2 to equal whatever date is entered into date plus 1 month. suggestions? Quote Link to comment Share on other sites More sharing options...
pdkv2 Posted February 6, 2008 Share Posted February 6, 2008 use DATE_ADD(now(), INTERVAL 1 MONTH); now() can be replaced by users input date Cheers ! Quote Link to comment Share on other sites More sharing options...
fenway Posted February 6, 2008 Share Posted February 6, 2008 NOW() + INTERVAL 1 MONTH saves some parents. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.