PHP - Count number of days between 2 dates

Question

I am trying to write a function that can count the number of days between 2 dates. I currently have the below but it is giving me some unexpected results:

function dayCount($from, $to) {
    $first_date = strtotime($from);
    $second_date = strtotime($to);
    $offset = $second_date-$first_date; 
    return floor($offset/60/60/24);
}

print dayCount($s, $e).' Days';

A couple of correct examples:

$s = '18-03-2016';
$e = '25-03-2016';

Outputs: 7 Days - correct

$s = '03-02-2016';
$e = '06-02-2016';

Outputs: 3 Days - correct

$s = '06-04-2016';
$e = '27-04-2016';

Outputs: 21 Days - correct

But when I have dates that cross over between 2 months sometimes it is correct, sometimes it shows a day less:

$s = '25-03-2016';
$e = '01-04-2016';

Outputs: 6 Days - should be 7 Days

$s = '23-02-2016';
$e = '01-03-2016';

Outputs: 7 Days - correct

It's not the "cross over between 2 months" that's causing the issue. The issue is intervals starting on or before '27-03-2016' and ending on or after '28-03-2016'. March 27, 2016 is the start of Daylight Saving Time (in the EU). When calculating a difference in seconds between two timestamps, from strings with different timezone offsets... in a timezone that observes DST, there's only 23 hours in March 27, 2016. — spencer7593
– spencer7593, Commented Jan 8, 2016 at 21:33

Jalpa · Accepted Answer · 2016-01-04 12:04:47Z

10

Please use diff function for get days between two date.

$date1 = new DateTime("25-03-2016");
$date2 = new DateTime("01-04-2016");

echo $diff = $date2->diff($date1)->format("%a");

answered Jan 4, 2016 at 12:04

Jalpa

7203 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

shiva chauhan · Accepted Answer · 2016-01-04 12:03:05Z

6

please use date_diff function like this

<?php
$date1=date_create("2013-03-15");
$date2=date_create("2013-12-12");
$diff=date_diff($date1,$date2);
echo $diff->format("%R%a days");
?>

hope this helps you thanx.

answered Jan 4, 2016 at 12:03

shiva chauhan

4202 silver badges7 bronze badges

1 Comment

user2559108 Over a year ago

Plus one for taking negative numbers in to account

Ren Camp · Accepted Answer · 2016-01-04 12:39:04Z

3

You can also use this (for versions PHP 5.1.5 and above without using date_diff()):

function dayCount($from, $to) {
    $first_date = strtotime($from);
    $second_date = strtotime($to);
    $days_diff = $second_date - $first_date;
    return date('d',$days_diff);
}

print dayCount($s, $e).' Days';

answered Jan 4, 2016 at 12:39

Ren Camp

4407 silver badges14 bronze badges

1 Comment

Mike Volmar Over a year ago

No leading 0 return date('j',$days_diff);

Collectives™ on Stack Overflow

PHP - Count number of days between 2 dates

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related