DBookatay Posted November 1, 2010 Share Posted November 1, 2010 I have a SQL row that has a date field: ex: 2010-11-01. When a car is sold there either is a 30 day warranty, a 60 day warranty, or 0 day warranty. What I'm trying to do is display when the vehicles warranty expires, based on the date it was sold, or when did it expire based on the same sold date pulled from the database. Example using last months date: 2010-10-01 60 day: "Expires 11-30-10" 30 day: "Expired 11-01-10" I can not seem to use the date function properly... Any help would be greatly appreciated. Quote Link to comment Share on other sites More sharing options...
AbraCadaver Posted November 1, 2010 Share Posted November 1, 2010 date('m-d-y', strtotime('+30 days', $row['date'])); Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted November 1, 2010 Share Posted November 1, 2010 Use strtotime & date <?php $date_sold = '2010-10-01'; echo '30 day: ' . date('Y-m-d',strtotime($date_sold . '+30 days')) . "<br>\n"; echo '60 day: ' . date('Y-m-d',strtotime($date_sold . ' +60 days')) . "\n"; ?> Ken 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.