Count months between two dates?

[deep]

Hello,

How can I count the number of months between two dates (format Y-m-d)without making things to complicated??

i just wrote this code... but its unstable! 🙁

   // OBS! $d_fst < $d_snd
   $d_fst = explode("-", "2004-02-28");
   $d_snd = explode("-", "2004-03-31");

   $years = $d_snd[0] - $d_fst[0];

   if($years == 0){
      $months = $d_snd[1] - $d_fst[1];
   }else{
      $months = ($years * 12) - $d_fst[1] + $d_snd[1];
   }

   // $d_fst day fix
   if(intval($d_fst[2]) > 27){
      $fst_add = -1;
   }else{
      $fst_add = 0;
   }

   // $d_snd day fix
   if(intval($d_snd[2]) > 27){
      $snd_add = 1;
   }else{
      $snd_add = 0;
   }
   echo $months + $fst_add + $snd_add;

Problem here is with the "day fix". Does anyone know a easier way to extract the number of months between two dates?

Thanks 🙂

[TheDefender]

Unfortunately, it's not an exact science because of the differences in the number of days in each month.

If you don't need it to be an exact number of months and are dealing with dates within the limits of strtotime (Jan 1, 1970 through Dec 31, 2038), then you may consider the following, which asically assumes 30 days per month:

How exact do you need this to be?

$d_fst = strtotime("2004-02-28"); 
$d_snd = strtotime("2004-03-31"); 

if($d_snd > $d_fst) {
	$timediff = ($d_snd-$d_fst);
} else {
	$timediff = ($d_fst-$d_snd);
}
$monthdiff = floor(($timediff/86400)/30);
echo $monthdiff;

[deep]

Nope, is has to be an exact number of months 🙂

[capte]

Heres a script we've build to show an images in between 2 exact dates ... hope it helps !

<?php
$complete_url = "http://www.TheLinkToWhatEverYouWant.php";
?>

<?
$array = array(

//Halloween//
"http://YourImage/halloween.gif"=>array("10/31/2005", "10/01/2005"),
//Action de grâce //

"http://YourImage/action.gif"=>array("10/10/2005", "10/11/2005"),
//Fin de l'heure avancé //

"http://YourImage/recule.gif"=>array("10/30/2005", "10/31/2005")
);

//So imagename.gif would be shown between 12/05/2005 and 12/25/2005 and imagename2.gif would be show between 12/25/2005 and 10/30/2006

// here's the code to display the right image:

$showDefault = true;

foreach($array as $key=>$value) {
$beginDate = $value[0];
$endDate = $value[1];

if((strtotime($beginDate) <= time()) && (strtotime($endDate) >= time())) {

$showDefault = false;
echo("<a href='$complete_url' ><img src=\"$key\" border='0'></a>");
}
}

if($showDefault) {
echo("<a href='$complete_url'><img src=\"YourImageByDefault/new_logo_toile_quebec.gif\" border='0'></a>");
}
?>

[deep]

I love that IF-statement !! So simple!!

Thanks a million! 🙂

[capte]

Glad i could help !

Capt. E