datediff (months and years)

[gcue 8]

im trying to get the date difference in months and years

$months = _DateDiff('M', $start_date, $end_date)

$years = $months / 12

how do i figure out how many months there are when its .3 for instance??

[water 1,935]

What is "its"? years or months?

Do you have an example with real dates to test?

Edited November 2, 2010 by water

[Realm 17]

gcue,

If you need a Integer call for both years and months, you could do something like this:

$total_months = _DateDiff('M', $start_date, $end_date)

$years = Floor($total_months / 12)

$months = $total_months-($years*12)

Realm

Edit: Fixed an error I wrote in the code.

Edited November 2, 2010 by Realm

[gcue 8]

hmm the result of these gives me 1 year and 11 months

$start_date = 2008-11-19 00:00:00

$end_date = 2010-11-02 00:00:00

thanks for your help realm!

water - sorry i wasnt clear. trying to get a more accurate change in datediff (showing # of years and months - to the nearest month). so like the dates shown above should be 2 years and 0 months?

Edited November 2, 2010 by gcue

[water 1,935]

You only get full months and years so the result is correct!

Edited November 2, 2010 by water

[gcue 8]

ooooo ur right!

sorry about that realm.. thanks water!!!

and thanks again realm =)