How to list all months between two dates

by

PHP 5.3

$start    = new DateTime('2010-12-02');
$start->modify('first day of this month');
$end      = new DateTime('2012-05-06');
$end->modify('first day of next month');
$interval = DateInterval::createFromDateString('1 month');
$period   = new DatePeriod($start, $interval, $end);

foreach ($period as $dt) {
    echo $dt->format("Y-m") . "<br>\n";
}

See it in action

PHP 5.4 or newer

$start    = (new DateTime('2010-12-02'))->modify('first day of this month');
$end      = (new DateTime('2012-05-06'))->modify('first day of next month');
$interval = DateInterval::createFromDateString('1 month');
$period   = new DatePeriod($start, $interval, $end);

foreach ($period as $dt) {
    echo $dt->format("Y-m") . "<br>\n";
}

The part where we modify the start and end dates to the first of the month is important. If we didn’t, and the current day higher then the last day in February (i.e. 28 in non-leap years, 29 in leap years) this would skip February.

More Related Contents:

  1. Display which day it is? sunday or monday “php coding”? [closed]
  2. Php date() Date and time is stuck [closed]
  3. PHP 01/01/1970 Issues with Date Fields
  4. Convert one date format into another in PHP
  5. Converting string to Date and DateTime
  6. Correctly determine if date string is a valid date in that format
  7. Compare given date with today
  8. PHP DateTime::modify adding and subtracting months
  9. Adding one day to a date
  10. Add ‘x’ number of hours to date
  11. The first day of the current month in php using date_modify as DateTime object
  12. How can I check if the current date/time is past a set date/time?
  13. Simplest way to increment a date in PHP?
  14. How to generate random date between two dates using php?
  15. PHP order array by date? [duplicate]
  16. Set timezone in PHP and MySQL
  17. PHP, Get tomorrows date from date
  18. Calculate total seconds in PHP DateInterval
  19. How to convert ISO8601 to Date format in php
  20. How do I find the hour difference between two dates in PHP?
  21. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  22. How do you explain the result for a new \DateTime(‘0000-00-00 00:00:00’)?
  23. adding 1 day to a DATETIME format value
  24. Get a PHP DateTime difference in days, considering midnight as a day change
  25. day of the week to day number (Monday = 1, Tuesday = 2)
  26. Converting to date in PHP from yyyymmdd format
  27. Subtracting a certain number of hours, days, months or years from date
  28. How do I convert an ISO8601 date to another format in PHP?
  29. Get date for monday and friday for the current week (PHP)
  30. Determine If Business Is Open/Closed Based On Business Hours

Leave a Comment