PHP Difference in months between two dates? [duplicate]

Question

Possible Duplicate:
How to calculate the difference between two dates using PHP?
Date Difference in php?

I have two dates in a variable like

$fdate = "2011-09-01" $ldate = "2012-06-06"

Now I need the difference in months between them.
For example, the answer should be 10 if you calculate this from month 09 (September) to 06 (June) of next year - you'll get 10 as result.
How can I do this in PHP?

Similar question link

cyberbemon
– cyberbemon

2012-05-03 08:29:14 +00:00
Commented May 3, 2012 at 8:29 — cyberbemon
– cyberbemon, Commented May 3, 2012 at 8:29
Duplicates: stackoverflow.com/search?q=date+difference+php

hakre
– hakre

2012-05-03 08:37:12 +00:00
Commented May 3, 2012 at 8:37 — hakre
– hakre, Commented May 3, 2012 at 8:37
Hope this helps stackoverflow.com/questions/676824/…

nithi
– nithi

2012-05-03 08:38:36 +00:00
Commented May 3, 2012 at 8:38 — nithi
– nithi, Commented May 3, 2012 at 8:38

Boby · Accepted Answer · 2012-05-04 07:13:27Z

24

A more elegant solution is to use DateTime and DateInterval.

<?php // @link http://www.php.net/manual/en/class.datetime.php $d1 = new DateTime('2011-09-01'); $d2 = new DateTime('2012-06-06'); // @link http://www.php.net/manual/en/class.dateinterval.php $interval = $d2->diff($d1); $interval->format('%m months');

answered May 4, 2012 at 7:13

Boby

8325 silver badges9 bronze badges

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

2 Comments

Matthew Over a year ago

This does not work if the interval is more than 12 months. A difference of 13 months will show up as 1. As a user mentioned in a comment on the other answer, you can use $interval->m + 12*$interval->y to fix this.

Christophe Le Besnerais Over a year ago

also, the result of $interval->m + 12*$interval->y will always be positive, you have to check $interval->invert and multiply by -1 or 1 accordingly : ($interval->invert ? -1 : 1) * ($interval->m + (12 * $interval->y))

Chintan · Accepted Answer · 2012-05-03 08:37:15Z

16

Have a look at date_diff:

<?php $datetime1 = date_create('2009-10-11'); $datetime2 = date_create('2009-10-13'); $interval = date_diff($datetime1, $datetime2); echo $interval->format('%m months'); ?>

edited May 3, 2012 at 8:37

Chintan

1,2041 gold badge8 silver badges23 bronze badges

answered May 3, 2012 at 8:28

Devator

3,9145 gold badges36 silver badges54 bronze badges

8 Comments

Jaiff Over a year ago

i got error while running this...Fatal error: Call to undefined function date_diff() in C:\test\test.php on line 4

Devator Over a year ago

@Jaiff Which PHP version are you running? 5.3 is required for this function.

Pez Cuckow Over a year ago

My point was, you're not taking into account the year here.

zzapper Over a year ago

add in the years with $interval->m + ($interval->y * 12)

Kamlesh Over a year ago

Calculate no of months between 2 dates: $date1 = '2017-01-20'; $date2 = '2019-01-20'; $ts1 = strtotime($date1); $ts2 = strtotime($date2); $year1 = date('Y', $ts1); $year2 = date('Y', $ts2); $month1 = date('m', $ts1); $month2 = date('m', $ts2); echo $joining_months = (($year2 - $year1) * 12) + ($month2 - $month1);

|

Collectives™ on Stack Overflow

PHP Difference in months between two dates? [duplicate]

2 Answers 2

2 Comments

8 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

8 Comments

Linked

Related