PHP Return all dates between two dates in an array

Question

Expected Input   getDatesFromRange   2010-10-01    2010-10-05       Expected Output   Array   2010-10-01    2010-10-02    2010-10-03    2010-10-04    2010-10-05

User · Answer

Here is a function  that will return date ranges in both directions and it works on PHP   5 2 2    function createRange  start   end   format    Y-m-d          start    new DateTime  start        end      new DateTime  end        invert    start  gt   end        dates   array         dates      start- gt format  format       while   start     end             start- gt modify   invert    -            1 day             dates      start- gt format  format             return  dates      Use example   print r createRange  2010-10-01    2010-10-05       Array        0    gt  2010-10-01      1    gt  2010-10-02      2    gt  2010-10-03      3    gt  2010-10-04      4    gt  2010-10-05      print r createRange  2010-10-05    2010-10-01    j M Y       Array        0    gt  5 Oct 2010      1    gt  4 Oct 2010      2    gt  3 Oct 2010      3    gt  2 Oct 2010      4    gt  1 Oct 2010       demo

User · Answer

report starting date date  2014-09-16     report ending date date  2014-09-26     report starting date1 date  Y-m-d  strtotime  report starting date  -1 day     while  strtotime  report starting date1  lt strtotime  report ending date           report starting date1 date  Y-m-d  strtotime  report starting date1   1 day          dates    report starting date1         print r  dates        dates      2014-09-16    2014-09-26        print result    Array    0    gt  2014-09-16  1    gt  2014-09-17  2    gt  2014-09-18  3    gt  2014-09-19  4    gt  2014-09-20  5    gt  2014-09-21  6    gt  2014-09-22  7    gt  2014-09-23  8    gt  2014-09-24  9    gt  2014-09-25  10    gt  2014-09-26

User · Answer

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             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  gt    iDateFrom            array push  aryRange  date  Y-m-d    iDateFrom       first entry         while   iDateFrom lt  iDateTo                 iDateFrom    86400     add 24 hours             array push  aryRange  date  Y-m-d    iDateFrom                        return  aryRange     source  http   boonedocks net mike archives 137-Creating-a-Date-Range-Array-with-PHP html

User · Answer

Short function  PHP 5 3 and up  Can take optional third param of any date format that strtotime can understand  Automatically reverses direction if end  lt  start   function getDatesFromRange  start   end   format  Y-m-d         return array map function  timestamp  use  format            return date  format   timestamp              range strtotime  start      start  lt   end   4000   8000   strtotime  end      start  lt   end   8000   4000   86400        Test   date default timezone set  Europe Berlin    print r getDatesFromRange   2016-7-28   2016-8-2      print r getDatesFromRange   2016-8-2   2016-7-28      print r getDatesFromRange   2016-10-28   2016-11-2      print r getDatesFromRange   2016-11-2   2016-10-28      print r getDatesFromRange   2016-4-2   2016-3-25      print r getDatesFromRange   2016-3-25   2016-4-2      print r getDatesFromRange   2016-8-2   2016-7-25      print r getDatesFromRange   2016-7-25   2016-8-2        Output   Array    0    gt  2016-07-28  1    gt  2016-07-29  2    gt  2016-07-30  3    gt  2016-07-31  4    gt  2016-08-01  5    gt  2016-08-02    Array    0    gt  2016-08-02  1    gt  2016-08-01  2    gt  2016-07-31  3    gt  2016-07-30  4    gt  2016-07-29  5    gt  2016-07-28    Array    0    gt  2016-10-28  1    gt  2016-10-29  2    gt  2016-10-30  3    gt  2016-10-31  4    gt  2016-11-01  5    gt  2016-11-02    Array    0    gt  2016-11-02  1    gt  2016-11-01  2    gt  2016-10-31  3    gt  2016-10-30  4    gt  2016-10-29  5    gt  2016-10-28    Array    0    gt  2016-04-02  1    gt  2016-04-01  2    gt  2016-03-31  3    gt  2016-03-30  4    gt  2016-03-29  5    gt  2016-03-28  6    gt  2016-03-27  7    gt  2016-03-26  8    gt  2016-03-25    Array    0    gt  2016-03-25  1    gt  2016-03-26  2    gt  2016-03-27  3    gt  2016-03-28  4    gt  2016-03-29  5    gt  2016-03-30  6    gt  2016-03-31  7    gt  2016-04-01  8    gt  2016-04-02    Array    0    gt  2016-08-02  1    gt  2016-08-01  2    gt  2016-07-31  3    gt  2016-07-30  4    gt  2016-07-29  5    gt  2016-07-28  6    gt  2016-07-27  7    gt  2016-07-26  8    gt  2016-07-25    Array    0    gt  2016-07-25  1    gt  2016-07-26  2    gt  2016-07-27  3    gt  2016-07-28  4    gt  2016-07-29  5    gt  2016-07-30  6    gt  2016-07-31  7    gt  2016-08-01  8    gt  2016-08-02

User · Answer

I think it s the shortest answer  Edit the code as you like  for   x strtotime  2015-12-01    x lt  strtotime  2015-12-30    x  86400  echo date  Y-m-d   x

User · Answer

Note that the answer provided by ViNce does NOT include the end date for the period   If you are using PHP 5 3   your best bet is to use a function like this          Generate an array of string dates between 2 dates        param string  start Start date     param string  end End date     param string  format Output format  Default  Y-m-d         return array     function getDatesFromRange  start   end   format    Y-m-d          array   array         interval   new DateInterval  P1D          realEnd   new DateTime  end        realEnd- gt add  interval         period   new DatePeriod new DateTime  start    interval   realEnd        foreach  period as  date              array      date- gt format  format               return  array      Then  you would call the function as expected   getDatesFromRange  2010-10-01    2010-10-05      Run demo  Note about DatePeriod class  You can use the 4th parameter of DatePeriod to exclude the start date  DatePeriod  EXCLUDE START DATE  but you cannot  at this time  include the end date

User · Answer

You could also take a look at the DatePeriod class    period   new DatePeriod       new DateTime  2010-10-01         new DateInterval  P1D         new DateTime  2010-10-05        Which should get you an array with DateTime objects   To iterate  foreach   period as  key   gt   value           value- gt format  Y-m-d

User · Answer

lt   print r getDatesFromRange   2010-10-01    2010-10-05       function getDatesFromRange  startDate   endDate         return   array  startDate        start    startDate       i 1      if  strtotime  startDate   lt  strtotime  endDate                while  strtotime  start   lt  strtotime  endDate                          start   date  Y-m-d   strtotime  startDate      i   days                  return      start               i                         return  return

User · Answer

Specify the start date  This date can be any English textual format    date from    2018-02-03       date from   strtotime  date from      Convert date to a UNIX timestamp       Specify the end date  This date can be any English textual format    date to    2018-09-10      date to   strtotime  date to      Convert date to a UNIX timestamp       Loop from the start date to end date and output all dates inbetween   for   i  date from   i lt   date to   i  86400          echo date  Y-m-d    i    lt br   gt

User · Answer

arr   range strtotime  2013-12-01   strtotime  2013-12-31     86400    array walk recursive  arr  function  amp  element     element   date  Y-m-d    element       print r   arr

User · Answer

function createDateRangeArray  start   end       Modified by JJ Geewax   range   array     if  is string  start      true   start   strtotime  start   if  is string  end      true    end   strtotime  end    if   start  gt   end  return createDateRangeArray  end   start    do    range     date  Y-m-d    start    start   strtotime    1 day    start     while  start  lt   end    return  range       Source  http   boonedocks net mike archives 137-Creating-a-Date-Range-Array-with-PHP html

User · Answer

Solution for PHP 5 2 with DateTime objects  But startDate MUST be before endDate   function createRange  startDate   endDate         tmpDate   new DateTime  startDate        tmpEndDate   new DateTime  endDate         outArray   array        do            outArray      tmpDate- gt format  Y-m-d          while   tmpDate- gt modify   1 day    lt    tmpEndDate        return  outArray      Using    dates   createRange  2010-10-01    2010-10-05       dates contain   Array   2010-10-01    2010-10-02    2010-10-03    2010-10-04    2010-10-05

User · Answer

This is short  sweet  and should work in PHP4    function getDatesFromRange  start   end        dates   array  start       while end  dates   lt   end            dates     date  Y-m-d   strtotime end  dates     1 day               return  dates

User · Answer

To make Mostafa s answer complete  this is definietly the simplest and most efficient way to do it   function getDatesFromRange  start date   end date   date format    Y-m-d               dates array   array          for   x   strtotime  start date    x  lt   strtotime  end date    x    86400             array push  dates array  date  date format   x                   return  dates array              see the dates in the array    print r  getDatesFromRange  2017-02-09    2017-02-19        You can even change the default output date format if you add a third parameter when you call the function  otherwise it will use the default format that s been set as  Y-m-d    I hope it helps

User · Answer

This is very very flexible          Creating date collection between two dates        lt code gt      lt  php      Example 1    date range  2014-01-01    2014-01-20     1 day    m d Y            Example 2  you can use even time    date range  01 00 00    23 00 00     1 hour    H i s        lt  code gt         author Ali OYGUR  lt alioygur gmail com gt      param string since any date  time or datetime format     param string until any date  time or datetime format     param string step     param string date of output format     return array     function date range  first   last   step     1 day    output format    d m Y            dates   array         current   strtotime  first        last   strtotime  last        while   current  lt    last               dates     date  output format   current            current   strtotime  step   current              return  dates

User · Answer

public static function countDays  date1  date2         date1   strtotime  date1      or your date as well      date2   strtotime  date2        datediff    date1 -  date2      return floor  datediff  60 60 24       public static function dateRange  date1  date2         count   static  countDays  date1  date2    1       dates   array        for  i 0  i lt  count  i                   dates     date  Y-m-d  strtotime  date2      i   days               return  dates

User · Answer

I love a solid one-liner   My php discovery of the day was that array push   returns the new number of elements in the array   I managed to check for the end date match  increment  x  and push new elements all within the two-part condition statement of an empty while loop   function getDatesFromRange  a  b  x 0  dates          while end  dates    b  amp  amp   x array push  dates date  Y-m-d  strtotime   a   x day           return  dates    var export getDatesFromRange  2010-10-01   2010-10-05       The most similar function to mine on this page is drolex s  which I didn t actually find until after I wrote mine  if you believe me    I did some speed tests across large and small date ranges and they seem to beat each other just as often -- so I m calling them equal performers   Here are some other comparisons    We both use date    strtotime    and two array functions  Drolex uses just three variables  I use the same three plus  x  Because loading the start date into the  date array is not necessary for my function  I can declare it in the function parameters and spare the line  likewise with  x       Just a couple of important notes   1- Date strings MUST BE validated before being fed to the function   2- The above function can only handle forward moving date ranges  If you want backward moving date ranges  simply reverse the date order in the function call and add a minus after  x     Pretty slick  eh    function getDatesFromRange  a  b  x 0  dates          while end  dates    b  amp  amp   x -array push  dates date  Y-m-d  strtotime   a   x day           return  dates    var export getDatesFromRange  2010-10-05   2010-10-01         One more extension consideration     Imagine you have a multi-cultural  or sloppy  user base  and your function MUST be able to receive start and end dates in different valid formats AND you need to be able to output the array in any of the valid formats   By minor adjustment  I ve provided a solution for that   By  valid  I mean YYYY-MM-DD  MM DD YYY  and DD-MM-YYYY  these are massively popular standards world-wide  if another format is necessary then usability would come down to strtotime s comprehension of it   Here is the Demo   Code   function getDatesFromRange  a  b  format  Y-m-d   dates     x 0       while date  format strtotime end  dates     date  format strtotime  b    amp  amp   x array push  dates date  format strtotime   a   x day           return  dates      formats array  Computer   gt  Y-m-d   American   gt  m d Y   Non-American   gt  d-m-Y     start  15-02-2017         Non-American formatted start date  end  2017-02-27       Computer formatted start date foreach  formats as  label  gt  format       echo   lt br gt  label lt br gt        var export getDatesFromRange  start  end  format        echo   lt br gt        Output  Computer array   0   gt   2017-02-15   1   gt   2017-02-16   2   gt   2017-02-17   3   gt   2017-02-18           4   gt   2017-02-19   5   gt   2017-02-20   6   gt   2017-02-21   7   gt   2017-02-22           8   gt   2017-02-23   9   gt   2017-02-24   10   gt   2017-02-25   11   gt   2017-02-26           12   gt   2017-02-27      American array   0   gt   02 15 2017   1   gt   02 16 2017   2   gt   02 17 2017   3   gt   02 18 2017           4   gt   02 19 2017   5   gt   02 20 2017   6   gt   02 21 2017   7   gt   02 22 2017           8   gt   02 23 2017   9   gt   02 24 2017   10   gt   02 25 2017   11   gt   02 26 2017           12   gt   02 27 2017      Non-American array   0   gt   15-02-2017   1   gt   16-02-2017   2   gt   17-02-2017   3   gt   18-02-2017           4   gt   19-02-2017   5   gt   20-02-2017   6   gt   21-02-2017   7   gt   22-02-2017           8   gt   23-02-2017   9   gt   24-02-2017   10   gt   25-02-2017   11   gt   26-02-2017           12   gt   27-02-2017       Now some people don t 100  trust strtotime   because of some buggy behaviors   I think I ve read that it will foul up when trying to jump a month from a leap-day   However  unless someone can reproduce it to prove me wrong  strtotime   is never going to let you down when you are only incrementing by one day

User · Answer

Here s a way of doing this using Carbon https   github com briannesbitt Carbon   public function buildDateRangeArray  first   last        while   first  lt    last             dates      first- gt toDateString              first- gt addDay               return  dates      This  of course  can be tweaked to not use Carbon  The  first and  last parameters passed to the function are Carbon instances

User · Answer

Simple but like a charm        period   new DatePeriod new DateTime  2015-01-01    new DateInterval  P1D    new DateTime  2015-01-15  1 day         foreach   period as  date             dates      date- gt format  Y-m-d                 ONLY SHOWING     echo   lt pre gt        var dump  dates       echo   lt  pre gt        exit

User · Answer

many ways of getting this done  but finally it all depends on PHP version you are using  Here is summary of all solutions   get PHP version   echo phpinfo      PHP 5 3    period   new DatePeriod       new DateTime  2010-10-01         new DateInterval  P1D         new DateTime  2010-10-05        PHP 4          creating between two date     param string since     param string until     param string step     param string date format     return array     author Ali OYGUR  lt alioygur gmail com gt      function dateRange  first   last   step     1 day    format    d m Y             dates   array         current   strtotime  first        last   strtotime  last        while   current  lt    last                dates     date  format   current            current   strtotime  step   current              return  dates      PHP  lt  4  you should upgrade

User · Answer

Here is the another solution  Please check this    first    10 30 2017     starting date  last   10 11 2017       ending date  first time arr explode      first     last time arr explode      last     create timestamp of starting date  start timestamp mktime 0 0 0   first time arr 0    first time arr 1   first time arr 2      create timestamp of ending date  end timestamp mktime 0 0 0   last time arr 0    last time arr 1   last time arr 2     date arr array    for  i  start timestamp  i lt   end timestamp  i  i 86400        date arr   date  Y-m-d   i     this will save all dates in array

User · Answer

You must add  end- modify   1 day   to include last day of interval  for example the January will have a 31 days instead of 30 without using modify   method  This version of code will include the last day of the interval    begin   new DateTime   2018-08-01      end   new DateTime   2018-08-31      end    end- gt modify    1 day        interval   new DateInterval  P1D     daterange   new DatePeriod  begin   interval   end    foreach  daterange as  date       echo  date- gt format  Ymd       lt br gt        PHP doc link

User · Answer

function GetDays  sStartDate   sEndDate              Firstly  format the provided dates             This function works best with YYYY-MM-DD            but other date formats will work thanks            to strtotime             sStartDate   gmdate  Y-m-d   strtotime  sStartDate             sEndDate   gmdate  Y-m-d   strtotime  sEndDate                Start the variable off with the start date         aDays      sStartDate             Set a  temp  variable  sCurrentDate  with           the start date - before beginning the loop         sCurrentDate    sStartDate             While the current date is less than the end date        while  sCurrentDate  lt   sEndDate               Add a day to the current date           sCurrentDate   gmdate  Y-m-d   strtotime   1 day   strtotime  sCurrentDate                  Add this new day to the aDays array           aDays      sCurrentDate                      Once the loop has finished  return the           array of days         return  aDays             use like  GetDays  2007-01-01    2007-01-31

User · Answer

will return dates array function returnBetweenDates   startDate   endDate         startStamp   strtotime    startDate         endStamp     strtotime    endDate         if   endStamp  gt   startStamp            while   endStamp  gt    startStamp                  dateArr     date   Y-m-d    startStamp                  startStamp   strtotime     1 day     startStamp                       return  dateArr           else          return  startDate            returnBetweenDates   2014-09-16    2014-09-26         print r  returnBetweenDates   2014-09-16    2014-09-26         it will return array like below   Array        0    gt  2014-09-16      1    gt  2014-09-17      2    gt  2014-09-18      3    gt  2014-09-19      4    gt  2014-09-20      5    gt  2014-09-21      6    gt  2014-09-22      7    gt  2014-09-23      8    gt  2014-09-24      9    gt  2014-09-25      10    gt  2014-09-26

User · Answer

function datesbetween   date1  date2         dates  array        for   i    date1           i lt    date1           i date add  i  date interval create from date string  1 days                                 dates     clone  i            return  dates

User · Answer

function getWeekdayDatesFrom  format   start date epoch   end date epoch   range          dates arr   array         if     range             range   round abs  start date epoch- end date epoch  86400    1        else            range    range   1    end date inclusive             current date epoch    start date epoch       for  i   1   i  lt    range   i 1              d   date  N     current date epoch            if  d  lt   5       not sat or sun              dates arr         date  format   current date epoch                           next day epoch   strtotime      i  day    start date epoch            i             current date epoch    next day epoch              return  dates arr

[php] PHP: Return all dates between two dates in an array

Examples related to php

Examples related to datetime

Examples related to date-range