# dateDiff giving bad results

**URL:** <https://forum.kirupa.com/t/datediff-giving-bad-results/329300>\
**Category:** Uncategorized\
**Created:** [August 10, 2012, 6:18pm UTC](https://forum.kirupa.com/t/datediff-giving-bad-results/329300 "2012-08-10T18:18:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasonhardwick](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@jasonhardwick](https://forum.kirupa.com/u/jasonhardwick)\
**Post date:** [August 10, 2012, 6:18pm UTC](https://forum.kirupa.com/t/datediff-giving-bad-results/329300/1 "2012-08-10T18:18:03Z")

</div>

ok I’m pulling a result list and trying to get the dateDiff between tow of the dates for each record. However my results aren’t coming out as expected. Can anyone help me and see why my code isn’t working (below).

Thanks

```php

echo '<td>' . mysql_result($result, $i, 'name') . '</td>';                
echo '<td>' . mysql_result($result, $i, 'address') . '</td>';                
echo '<td>' . mysql_result($result, $i, 'system_size') . '(w)' . '</td>';                
echo '<td>' . mysql_result($result, $i, 'contract_date') . '</td>';                
echo '<td>' . mysql_result($result, $i, 'install_complete') . '</td>';                                    
$start_date = strtotime('contract_date');                    
$end_date = strtotime('install_complete');
$days_between = floor(abs($end_date - $start_date) / 86400);                                    
echo '<td>' . mysql_result($result, $i, $days_between) . '</td>';

```