Topic: [SOLVED] Date Comparison Failing.

[hellonoko]

Code: [Select]

echo $daystillupload = date('Y-m-d') - "2008-11-18";

Is my code to compare the current date with the last login date and display how many days since a person last logged in. This should return 1. But returns 0? What am I doing wrong.

Thanks,
ian

[Mark Baker]

Try doing things the other way round, converting the human-readable dates to PHP date/time stamps, then doing the mathematics

[hellonoko]

Tried:

Code: [Select]

$daystillupload = strtotime(date('Y-m-d')) - strtotime($lastuploaddate);

And:

Code: [Select]

$daystillupload = date('Y-m-d') - strtotime($lastuploaddate);

Both return: 1226989592

$lastuploaddate contains 2008-11-18

[premiso]

They return what is expected the timestamp.

try this:



$daystillupload = time() - strtotime($lastuploaddate); // just use time

echo date('Y-m-d', $daystillupload); // use date here for displaying.

[hellonoko]

I found this solution that seems to work well.

Code: [Select]

function compareDates($date1,$date2)
{
$date1_array = explode("-",$date1);
$date2_array = explode("-",$date2);

$timestamp1 = mktime(0,0,0,$date1_array[1],$date1_array[2],$date1_array[0]);
$timestamp2 = mktime(0,0,0,$date2_array[1],$date2_array[2],$date2_array[0]);

return ($timestamp1 - $timestamp2);


}

$daystillupload = compareDates( $date = date('Y-m-d'), $lastuploaddate) / 86400;