array with dates between two different dates

Question

I am currently working on a calender script for my personal use. Therefore I need your help :-)

I have two dates in format YYYY-MM-DD.

for example:

2012-05-12 and
2012-05-16

What I need is the dates between them:

2012-05-13
2012-05-14
2012-05-15

The output should be in an array. I dont now how to start anyway... so do u have a hint?

possible duplicate of Add missing dates to an array

JJJ
– JJJ

2012-07-12 12:36:07 +00:00
Commented Jul 12, 2012 at 12:36 — JJJ
– JJJ, Commented Jul 12, 2012 at 12:36

dan-lee · Accepted Answer · 2012-07-12 12:18:50Z

5

Here's the OOP approach, you should use it:

$a = new DateTime('2012-05-12');
$b = new DateTime('2012-05-16');

// to exclude the end date (so you just get dates between start and end date):
// $b->modify('-1 day');

$period = new DatePeriod($a, new DateInterval('P1D'), $b, DatePeriod::EXCLUDE_START_DATE);

foreach($period as $dt) {
  echo $dt->format('Y-m-d');
}

For further reading see DateTime, DateInterval and DatePeriod.

answered Jul 12, 2012 at 12:18

dan-lee

14.5k6 gold badges55 silver badges81 bronze badges

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

Comments

Gunther Konig · Accepted Answer · 2012-08-04 16:56:15Z

3

$date =  date("Y-m-d", strtotime("2012-05-12"));
$final_date = date("Y-m-d", strtotime("2012-05-16"));
while($date < $final_date){
   $date = date("Y-m-d", strtotime($date . " +1 day"));
   $dates[] = $date;
}

edited Aug 4, 2012 at 16:56

Gunther Konig

1821 silver badge7 bronze badges

answered Jul 12, 2012 at 12:15

Razvan

10.2k6 gold badges41 silver badges51 bronze badges

1 Comment

SilverSnake Over a year ago

This is how I would do it as well. Don't forget the closing curly brace that fell outside the code box! :)

Ovidiu · Accepted Answer · 2012-07-13 09:55:27Z

1

function getDates($startTime, $endTime) {
    $day = 86400;
    $format = 'Y-m-d';
    $startTime = strtotime($startTime);
    $endTime = strtotime($endTime);
    //$numDays = round(($endTime - $startTime) / $day) + 1;
    $numDays = round(($endTime - $startTime) / $day); // remove increment 

    $days = array();

    for ($i = 1; $i < $numDays; $i++) { //change $i to 1
        $days[] = date($format, ($startTime + ($i * $day)));
    }

    return $days;
}

$days = getDates('2012-05-12', '2012-05-16');

Output:

Array
(
    [0] => 2012-05-13
    [1] => 2012-05-14
    [2] => 2012-05-15
)

As Dan Lee said, I changed the function to get only the date interval, excluding the first and last day from array.

edited Jul 13, 2012 at 9:55

answered Jul 12, 2012 at 12:19

Ovidiu

2,9315 gold badges30 silver badges36 bronze badges

2 Comments

user1137370 Over a year ago

Just your function names are not the same :D

dan-lee Over a year ago

You are not getting the desired result with this function.

Peon · Accepted Answer · 2012-07-12 12:17:19Z

1

function GetDays ($sStartDate, $sEndDate ) {  
  $sStartDate = gmdate( 'Y-m-d', strtotime( $sStartDate ) );  
  $sEndDate = gmdate( 'Y-m-d', strtotime( $sEndDate ) );  

  $aDays[] = $sStartDate;  

  $sCurrentDate = $sStartDate;  

  while( $sCurrentDate < $sEndDate ) {  
    $sCurrentDate = gmdate( 'Y-m-d', strtotime( '+1 day', strtotime( $sCurrentDate) ) );  

    $aDays[] = $sCurrentDate;  
  }  

  return $aDays;  
}  

print_r ( '2012-05-12', '2012-05-16' );

answered Jul 12, 2012 at 12:17

Peon

8,0417 gold badges63 silver badges104 bronze badges

Comments

user1437178 · Accepted Answer · 2012-07-12 12:20:20Z

Here is the code:

function createDateRangeArray($strDateFrom,$strDateTo)
    {
        // takes two dates formatted as YYYY-MM-DD and creates an
        // inclusive array of the dates between the from and to dates.

        // could test validity of dates here but I'm already doing
        // that in the main script

        $aryRange=array();

        $iDateFrom=mktime(1,0,0,substr($strDateFrom,5,2),     substr($strDateFrom,8,2),substr($strDateFrom,0,4));
        $iDateTo=mktime(1,0,0,substr($strDateTo,5,2),     substr($strDateTo,8,2),substr($strDateTo,0,4));

        if ($iDateTo>=$iDateFrom)
        {
            array_push($aryRange,date('Y-m-d',$iDateFrom)); // first entry
            while ($iDateFrom<$iDateTo)
            {
                $iDateFrom+=86400; // add 24 hours
                array_push($aryRange,date('Y-m-d',$iDateFrom));
            }
        }
        return $aryRange;
    }

I have taken a reference from this website.

Collectives™ on Stack Overflow

array with dates between two different dates

5 Answers 5

Comments

1 Comment

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related