Months in selected date range.

[girish.kc]

I am working on a report generation. Here I need to count the number of months involved in the selected date range. I need to apply the monthly charges accordingly.

 

Example: If the user selects 25-08-2011 to 03-10-2011, it should return 3 as the number of months.

 

Yes, the number of days are less than 60 but still the date range is spread across 3 months.

 

Any solution.. Please.

 

Girish

[silkfire]

With a little bit thinking I came up with this function:

 

function count_months($date_from, $date_to) {
   return round((strtotime('last day of this month', strtotime($date_to)) - strtotime('first day of this month', strtotime($date_from))) / 2629743.83);
}

echo count_months('25-08-2011', '03-10-2011');

[girish.kc]

Hi silkfire,

Very quick replay..

Thanks a lot. 

 

[silkfire]

2629743.83 is the amount of seconds in a month. The calculation return something with 2.99043234 so that's why we're rounding before returning the result. Glad I could help ya.