PHP, see if date range is partly within another date range

Question

I've been looking forever for this, but the answer seems nowhere. Here's the problem:

Say, I've got two date ranges.

$daterange1 = 2012-04-20 till 2012-04-28 
$daterange2 = 2012-04-18 till 2012-05-01

Now, I'd like to know if daterange2 is within daterange1. But, as you can see, daterange2 only partly is within daterange1. Is there any way of getting 3 variables back, something like:

2012-04-18 till 2012-04-20
2012-04-20 till 2012-04-28
2012-04-28 till 2012-05-01

I know it sounds a little vague, but I really don't know how to explain it different.

I understand the question, you may want to convert all the times with the strtotime() function and start comparing. Maybe a DateTime object will help you here as well. — Madara's Ghost
– Madara's Ghost, Commented Jan 3, 2012 at 19:59
do you need to know if the range is within and the 3rd variable — Laurence Burke
– Laurence Burke, Commented Jan 3, 2012 at 20:10

user895378 · Accepted Answer · 2012-01-03 20:06:45Z

7

Here's an example using PHP's DateTime class. Note that if you pass an invalid date string to DateTime::__construct() the function will throw an exception, so you should implement a try/catch block if you're worried about this. Also, I use PHP's min and max functions so that it doesn't matter which order the dates are specified.

$daterange1 = array('2012-04-20', '2012-04-28');
$daterange2 = array('2012-04-18', '2012-05-01');

$range_min = new DateTime(min($daterange1));
$range_max = new DateTime(max($daterange1));

$start = new DateTime(min($daterange2));
$end = new DateTime(max($daterange2));

if ($start >= $range_min && $end <= $range_max) {
  echo 'woot!';
} else {
  echo 'doh!';
}

answered Jan 3, 2012 at 20:06

user895378

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

Comments

lorem monkey · Accepted Answer · 2013-08-14 09:55:55Z

7

Well, logically you can break down the requirements for a range to be partly in another.

A range is only partly within another range if:

range1's start date is > than range2's start date but not > than range2's end date
range1's end date is < than range2's end date but not < than range2's start date

If either or both of those are true then the ranges are within each other.

edited Aug 14, 2013 at 9:55

lorem monkey

4,0023 gold badges37 silver badges49 bronze badges

answered Jan 3, 2012 at 20:02

Laurence Burke

2,36814 silver badges26 bronze badges

Comments

Koushik Basu · Accepted Answer · 2017-09-26 06:36:50Z

0

Though this is a very old post. But still if someone stuck. Here's complete example for overlapping dates.

<?php
$daterange1 = array('2017-09-24', '2017-09-28');
$daterange2 = array('2017-09-22', '2017-09-25');

$range_min = new DateTime(min($daterange1));
$range_max = new DateTime(max($daterange1));

$start = new DateTime(min($daterange2));
$end = new DateTime(max($daterange2));

if ($start >= $range_min && $end <= $range_max) {
echo 'Overlapping!';
} 
else if($end > $range_min && $start < $range_max){
echo "partialy";
}
else {
echo 'free!';
}
?>

answered Sep 26, 2017 at 6:36

Koushik Basu

387 bronze badges

Collectives™ on Stack Overflow

PHP, see if date range is partly within another date range

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related