Month difference between two dates - yyyymm format

Question

I wanted to calculate the month difference between two yyyymm dates. I have this function below, however it only works if I use yyyy-mm instead.

$date1 = new DateTime('2014-01');
$date2 = new DateTime('2013-06');
$mth = mthdiff($date1, $date2);

function mthdiff($date1,$date2){


$diff = $date1->diff($date2);

return (($diff->format('%y') * 12) + $diff->format('%m'));

}

Use `date_parse_from_format` to parse a date in the form you specify. — Barmar, Apr 17 '14 at 07:25

score 3 · Accepted Answer · answered Apr 17 '14 at 07:26

Modify your function to use DateTime::createFromFormat():

function mthdiff($date1,$date2){
    $d1 = DateTime::createFromFormat('Ym', $date1);
    $d2 = DateTime::createFromFormat('Ym', $date2);
    $diff = $d1->diff($d2);
    return (($diff->format('%y') * 12) + $diff->format('%m'));
}

Usage:

echo mthdiff('201401', '201306');

Output:

Demo

Month difference between two dates - yyyymm format

1 Answers1

Linked