total of months in 1 year

in my db, i have
date start = August 16, 2007
date end = August 15, 2008
now i would to how to get the number of months between that 2 dates

tnx n advance :wink:

so u want every month to be count?
so ur example would return 13, because August is counted twice?

what i would do is:
//preset data:


//make them a timestamp

//month since 1.1.0000

//calculate the difrence

//of cause this can be written in one statement:

Sponsor our Newsletter | Privacy Policy | Terms of Service