Difference between 2 dates using PHP

hi,

 

having issues calculating difference between 2 dates.

i have noticed around half of results output 552 months... should around 24 months...

 

i have noticed records display incorrect calculation have months of date less current month, sets $date2 01/01/1970

 

this code:

 

<?php

  //calculate months remaining

  $date1 = date('d/m/y');

  $date2 = $renewal_row['enddate'];

  //$date2 = date('d/m/y', strtotime(str_replace('.', '-', $renewal_row['enddate'])));

 

  $diff = abs(strtotime($date2) - strtotime($date1));

 

  $years = floor($diff / (365*60*60*24));

  $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));

  $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));

 

  //printf("%d years, %d months, %d days\n", $years, $months, $days);

  $months_remaining = ($years*12) + $months;

  ?>

               

<?php echo '$date1='.strtotime($date1).'('.$date1.') date2='.strtotime($date2).'('.$date2.') difference='.$diff; ?>

 

date correct difference between both dates:

$date1=1452038400(01/06/2016) date2=1520035200(03/03/2018) difference=67996800

 

date incorrect difference:

$date1=1452038400(01/06/2016) date2=(20/11/2016) difference=1452038400

 

notice if month in $date2 greater current month (june) messes up.

 

any appreciated!

you start right off defining dates in format d/m/y. that's first mistake. whole approach wrong.

 

use php datetime class. thing of beauty. 1 of nice things keeps track of date date , return formatted value when need display date web page.

 

david powers has thorough tutorial on php dates @ lynda.com. highly recommend it.

 

by way, 1/1/1970 php returns when can't parse date.

More discussions in Dreamweaver support forum

adobe