Elegant way to get the count of months between two dates?

by

For PHP >= 5.3

$d1 = new DateTime("2009-09-01");
$d2 = new DateTime("2010-05-01");

var_dump($d1->diff($d2)->m); // int(4)
var_dump($d1->diff($d2)->m + ($d1->diff($d2)->y*12)); // int(8)

DateTime::diff returns a DateInterval object

If you don’t run with PHP 5.3 or higher, I guess you’ll have to use unix timestamps :

$d1 = "2009-09-01";
$d2 = "2010-05-01";

echo (int)abs((strtotime($d1) - strtotime($d2))/(60*60*24*30)); // 8

But it’s not very precise (there isn’t always 30 days per month).

Last thing : if those dates come from your database, then use your DBMS to do this job, not PHP.

Edit: This code should be more precise if you can’t use DateTime::diff or your RDBMS :

$d1 = strtotime("2009-09-01");
$d2 = strtotime("2010-05-01");
$min_date = min($d1, $d2);
$max_date = max($d1, $d2);
$i = 0;

while (($min_date = strtotime("+1 MONTH", $min_date)) <= $max_date) {
    $i++;
}
echo $i; // 8

More Related Contents:

  1. Display which day it is? sunday or monday “php coding”? [closed]
  2. Calculate business days
  3. How to find the last day of the month from date?
  4. Compare given date with today
  5. How to convert date to timestamp in PHP?
  6. A non well formed numeric value encountered
  7. PHP setlocale has no effect
  8. Date Difference in php on days? [duplicate]
  9. Round minute down to nearest quarter hour
  10. Adding minutes to date time in PHP
  11. Calculating days of week given a week number
  12. increment date by one month
  13. PHP date format /Date(1365004652303-0500)/
  14. Set timezone in PHP and MySQL
  15. PHP, Get tomorrows date from date
  16. Calculate total seconds in PHP DateInterval
  17. Date minus 1 year?
  18. How to parse a date string in PHP?
  19. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  20. PHP date time greater than today
  21. Formatting an SQL timestamp with PHP
  22. php – add two hours to date variable
  23. date() method, “A non well formed numeric value encountered” does not want to format a date passed in $_POST
  24. MySQL, how to insert null dates
  25. Converting to date in PHP from yyyymmdd format
  26. Subtracting a certain number of hours, days, months or years from date
  27. How can I work with dates before 1900 in PHP?
  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