Question about date calculations

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello List,

 

I am using PHP version 5.2.6.

 

I have a page I am trying to create where I am comparing the values of two
MySQL date fields with the current date. One of the MySQL Date fields is a
class start date, the other is the class end date.

 

First I need to calculate the number of days between class start and end
date. Then based on the number of days between these to dates I have to find
out how close the current date is to the class end date.

 

So far in looking at the functions that are available at
http://www.php.net/manual/en/ref.datetime.php I have not been able to figure
out how to do what I need to do.  Below is a snippet showing approximately
what I am trying to do.

 

<?PHP

...

  $dteStartDate[$intCnt]= New DateTime($row[10]);

  $dteEndDate[$intCnt]= New DateTime($row[11]);

...

  $dteCheckDate=date('Y-m-d');

  $intDayCnt=$dteEndDate[$i]-$dteStartDate[$i];

  if (($dteCheckDate>=($dteEndDate[$i]-7) &&
$dteCheckDate<=($dteEndDate[$i]+1)) && $intDayCnt<16)

...

?>

 

My start date is 12/26/2011, the end date 1/8/2012 so the value for
&intDayCnt should be 13, but it is coming up as 0.

 

Also the check date which is 12/29/2011 is being calculated as after my end
date.  Can someone point me in the direction of what I need to do to have
the comparisons I am doing work.

 

Eric Lommatsch. 


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux