Some help with dates?

ShiggyWiggy

Hello, looking for some help with dates in php.

I'm using two dates for a project I'mworking on. A start date and an end date.
Start date is just todays date. Using:
$dateCreated = Date('y-m-d');

to do this. Want the end date to be something like 60 days from the start date. Have tried a few different ways of doing this but none seem to insert a valid date into my mySQL database table.

Can anyone help out?
Will I need to change the format of the $dateCreated to something that can be used to calculate a future date?

Thanks if you can offer some help.

Shrike

Check out [MAN]strtotime[/MAN] and particularly the GNU date format.

ShiggyWiggy

Thanks.
Managed to get it to display the date in the following format - January 05 ,2005 but any idea how I conver that to 2005-01-05 so that I can insert it into the database table?

ShiggyWiggy

managed to get it working, opted to just use the mysql function date_add and update the end date using the date it was created.

Thanks for the help though.

TheDefender

Thanks.
Managed to get it to display the date in the following format - January 05 ,2005 but any idea how I conver that to 2005-01-05 so that I can insert it into the database table?

Shrike already gave you the function to do that...

[man]strtotime[/man] will accept the input you gave, and use that in conjunction with the [man]date[/man] function to output it as you want it. Just remember, the strtotime functino will only work with dates later than January 1, 1970.

// Your inputted date format
$date = "January 05, 2005";

// Convert it to the format you want
$dateconvert = date("Y-m-d", strtotime($date));

// Echo it to make sure it's what you want.
echo $dateconvert;