Date calculating

[thoand]

How can I calculate how many days threre are between
eg.
2003-03-17 to 2004-06-15

thanks in advance for tips and guides

regards Thomas

[The_Chancer]

Convert to timestamp

Take one away from the other

Divide by 86400... voila...

One method anyway...

[Norman_Graham]

If it's a MySQL query, you can of course use TO_DAYS(), i.e.:

TO_DAYS(date2) - TO_DAYS(date1)

HTH

Norm

[baronmask]

Dear Thoand,
here is a small code for you:

assume there are 2 variables name $datesatu and $datedua, each carrying date with Y-m-d format

<?php

if($action == 'count')
{
	$d1 = substr($datesatu,8,2) ;
	$m1 = substr($datesatu,5,2) ;
	$y1 = substr($datesatu,0,4) ;
	$d2 = substr($datedua,8,2) ;
	$m2 = substr($datedua,5,2) ;
	$y2 = substr($datedua,0,4) ;

echo "$d1, $m1, $y1, $d2, $m2, $y2";
$diff = (mktime(0,0,0,$m1,$d1,$y1) - mktime(0,0,0,$m2,$d2,$y2))/86400; 
echo "<br>Different = $diff days";
}

?>