Date Math

[rob_maguire]

Using PHP/MYSQL, I have this code:

<?php echo date ("m/d/Y",strtotime($row_gethistory['date'] +2 months")); ?>

I get a parse error ... just want to be able to add 2 months (or whatever) to the 'DATE' field pulled from the database

Thanks

[drawmack]

hmmm maybe

assumption:
date is stored in standard mysql format of YYYY-MM-DD

$year = substr($row_gethistory['date'] ,0,4);
$month = substr($row_gethistory['date'] ,5,2);
$day = substr($row_gethistory['date'] ,8);

$newMonth = (($month+2) mod 12) + 1;
if($newMonth < $month) {$year++;}

$test = strtotime("$newMonth-1-$year");
if(date("t",$test) < $day) {
  $newMonth++;
  $day = ($day - date("t",$test));
}

$finished = strtotime("$newMonth-$day-$year");

[seby]

try:

echo date("m/d/y",strtotime('+2 months',+$row_gethistory['date']));

note: this only works if you're timestamp in mysql is in unix format.

[rob_maguire]

My date format is stored in standard mysql format of YYYY-MM-DD. I do not get an error with:

echo date("m/d/y",strtotime('+2 months',+$row_gethistory['date']));

but the date comes out weird

[HalfaBee]

If your field is a DATE or similar try this

echo date("m/d/y",strtotime('+2 months '.$row_gethistory['date']));

HalfaBee

[rob_maguire]

Works! ... Thanks!!