unexpected date calc results

craigh

could anyone tell me why this code is not producing the expected results? I would expect this code to return a timedifference of 5 days. Instead I get 595! Help!

$currenttime = time();
echo "mktime: $currenttime "; //produces 990396193
echo "Current time: ". strftime("%Y-%m-%d" ,$currenttime)." "; //produces 2001-05-20
$dbase_date="2001-05-25";
echo "dbase date: $dbase_date "; //produces 2001-05-25
list($year, $month, $day) = explode("-", $dbase_date);
$newdate=mktime(0, 0, 0, $day, $month, $year);
echo "mktime: $newdate "; // produces 1041742800
$timedifference =$currenttime-$newdate;
$retval = $timedifference/86400; //86400 seconds in a day
$daysdiff = floor($retval);
echo "days different: $daysdiff "; //produces -595

Anon

you called mktime with the params in the wrong order.

$currenttime = time();
echo "mktime: $currenttime "; //produces 990396193
echo "Current time: ". strftime("%Y-%m-%d" ,$currenttime)." "; //produces 2001-05-20
$dbase_date="2001-05-25";
echo "dbase date: $dbase_date "; //produces 2001-05-25
list($year, $month, $day) = explode("-", $dbase_date);
$newdate=mktime(0, 0, 0, $month, $day, $year); # [CHANGED] ... you had $month and $day in the wrong order
echo "mktime: $newdate "; // produces 1041742800
$timedifference = $currenttime - $newdate;
$retval = $timedifference/86400; //86400 seconds in a day
$daysdiff = floor($retval);
echo "days different: $daysdiff "; //produces -595

Anon

the way you've called mktime()
could be the problem here.

mktime(0,0,0,$month,$day,$year);

Here the month comes b4 the date, its a bit
tricky.

hope this helps

craigh

thanks to both of you. I thought I'd checked that. guess not! ;-)