PHP - Calculate Days Between Two Dates

I've tried several scripts to get the number of days between two dates, but none of them will work. Obviously I'm doing something wrong. One thing I know that is causing a problem is that I'm using variables instead of an actual typed in date. Which in my opinion is how most people would do it - variables not actual dates.

I've tried these:

$todaydate = date('Y/m/d');
$now = date('Y-m-d');
$dd2 = strtotime($now);
$thisyear = 2019;
$payment_day = 29;
$pay_month = 6;

if($pay_month == 1){$newpaymentmonth = 2;}
if($pay_month == 2){$newpaymentmonth = 3;}
if($pay_month == 3){$newpaymentmonth = 4;}
if($pay_month == 4){$newpaymentmonth = 5;}
if($pay_month == 5){$newpaymentmonth = 6;}
if($pay_month == 6){$newpaymentmonth = 7;}
if($pay_month == 7){$newpaymentmonth = 8;}
if($pay_month == 8){$newpaymentmonth = 9;}
if($pay_month == 9){$newpaymentmonth = 10;}
if($pay_month == 10){$newpaymentmonth = 11;}
if($pay_month == 11){$newpaymentmonth = 12;}
if($pay_month == 12){$newpaymentmonth = 1;}

$threezero = array(4, 6, 9, 11); // months with 30 days

// Deal with months that have only 28 days or 30 days, setting the payment day to accommodate months with fewer days.
if ($payment_day > 28 && $pay_month == 2)
{
    $payment_day = 28;
}
elseif ($payment_day == 31 && in_array($pay_month, $threezero))
{
    $payment_day = 30;
}
else
{
    $payment_day = $payment_day;
}

if ($newpaymentmonth == 1){$newpaymentyear = $thisyear + 1;}else{$newpaymentyear = $thisyear;}
$newpaymentdate = date($newpaymentyear.'-'.$newpaymentmonth.'-'.$payment_day);
echo date("Y-m-d", $newpaymentdate) . "<br><br>";

$ddate = new DateTime($thisyear.'-'.$newpaymentmonth.'-'.$payment_day);
$ddate->add(new DateInterval('P5D'));
echo $ddate->format('Y-m-d') . " - New month payment date with 5 day grace period added.<br><br>";

Now, how to calculate the difference in days between today's date and $ddate? I tried the below, but none worked.
 

function DateDiff($strDate1,$strDate2){
return (strtotime($strDate2) - strtotime($strDate1))/  ( 60 * 60 * 24 );  // 1 day = 60*60*24
}
echo "Date Diff = ".DateDiff($now,$ddate)."<br>";

$timeDiff = abs($now - $ddate);
$numberofdays = $timeDiff/86400;
echo "<p>$numberofdays - days between today's date and payment w/grace date.</p>";

$date1 = $now;
$date2 = $ddate;
$diff = date_diff($date1,$date2);
echo 'Days Count - '.$diff->format("%a");

$date1=$now;
$date2=$ddate;
function dateDiff($date1, $date2)
{
      $date1_ts = strtotime($date1);
      $date2_ts = strtotime($date2);
      $diff = $date1_ts - $date2_ts;
      return round($diff / 86400);
}
$dateDiff= dateDiff($date1, $date2);
printf("Difference between in two dates : " .$dateDiff. " Days ");
print "</br>";

This one returns 18112 Days. Should be days 7 days from 2019-08-05.

None of these work, so I'm doing something wrong. Any ideas?

Thanks

I have date stored in database in any of the given forms 2020-06-01, 2020-05-01 or 2019-04-01

I want to compare the old date with current date 2020-06-14

And the result should be in days.

Any help please?

PS: I want to do it on php side. but if its possible to do on database side (I am using myslq) please share both ways🙂

Hi,

I need to calculate absent percentage but not sure how. working days from Sunday to Thursday every week so 5 working days a week. i will calculate the absent days from joining date until current date. Example if joining date is 24-3-2020 and today's date is 7-4-2020 i should get the number of absent days to 11 days since both Friday and Saturday are excluded. How to do that?

here is what I have:

$workingdays = $curdate - $joindate;
$workingdays = $workingdays - 				
$absent = ($counter / $workingdays) * 100;

the second line i missing the number of days for (Fridays and Saturdays) that should be excluded from calculations. The third line i did calculate the actual working days ($counter) for the employee so then i can get percentage of absent days. How to exclude the weekend days from calculations?

Hi, I have this code :-

$datestarted = $row['datestarted'];
$datestart=date("l d/m/Y @ H:i:s",strtotime($datestarted)); 

Which is been echo'd like this :-

echo '
<tr align="center"'.$rowbackground.'>
<td>'.$datestart.'</td>							
<td align="center">
';

So for example I get this output :-Sunday 18/04/2021 @ 10:45:26

The data in the DB for the above is stored like this :-2021-04-18 10:45:26

What I'd like to do is also echo how many days ago this date was, all of the examples I've tried don't seem to work though?