calculate number of days between 2 dates in php

Question

I need to calculate difference between 2 dates here is my dates

$start = strtotime('17/05/2016');
$end = strtotime('12/05/2016');

I have tried

  echo $days_between = ceil(abs($end - $start) / 86400);

But it shows output as 17140

Hep to find the number of days between 2 given dates

http://stackoverflow.com/questions/1607336/calculate-difference-between-two-dates-number-of-days?rq=1 — zoubida13, May 12 '16 at 15:35
`12/05/2016` is being read as december 5 2016. `17/05/2016` is read as invalid so it is empty. So your equation is `strtotime('12/05/2016') / 86400`. — chris85, May 12 '16 at 15:36

score 2 · Accepted Answer · answered May 12 '16 at 15:39

2

You just need to specify what is the date format, so:

$date1 = DateTime::createFromFormat('d/m/Y',"12/05/2016");
$date2 = DateTime::createFromFormat('d/m/Y',"17/05/2016");
echo $diff = $date2->diff($date1)->format("%a"); //output: 5

answered May 12 '16 at 15:39

mitkosoft

5,262
1
13
31

score 0 · Answer 2 · answered May 12 '16 at 15:44

You need to change the format: with d/m/Y at m/d/Y

You can also use a format like this:

$s = DateTime::createFromFormat('d/m/Y', '17/05/2016');
$d = DateTime::createFromFormat('d/m/Y', '05/12/2016');

And get the difference of days:

$start = DateTime::createFromFormat('d/m/Y', '17/05/2016');
$end = DateTime::createFromFormat('d/m/Y', '12/05/2016');
$interval = $end->diff($start);
$days = $interval->format('%a');

score 0 · Answer 3 · answered May 12 '16 at 15:45

You are using a wrong format for dates, the original is: "Y-m-d" not "d/m/Y", you can use something like this if you could change the date format:

 $now = strtotime("2016-05-17"); // or your date as well
 $your_date = strtotime("2016-05-12");
 $datediff = $now - $your_date;
 echo floor($datediff/(60*60*24));

calculate number of days between 2 dates in php

3 Answers3