get months between dates

[kay]

I have start date end End date,
I am able to find the month for start date and end date.
for eg if Start Date = 10/1/2008 and end date is 12/1/2008
then month for start date is 10 and month for end date is 12
but i want all the month between 10 and 12 so it should return 10,11,12

Thanks!

 

[KARL DEWEY]

Post example of raw data and resulting data.

 

[John W. Vinson]

I have start date end End date,
I am able to find the month for start date and end date.
for eg if Start Date = 10/1/2008 and end date is 12/1/2008
then month for start date is 10 and month for end date is 12
but i want all the month between 10 and 12 so it should return 10,11,12

Thanks!

What do you want if startdate is 10/1/2007 and enddate is 3/1/2009?