>You have two dates, say 12-31-2007 and 03-01-2008. How can I count how months there are from 1st date to 2nd date. The answer I'm looking for is 4 (Dec 07, Jan 08, Feb 08, and Mar 08) - (Given the days maybe 28,29,30,or 31)
Jim,
I'm sorry, I didn't look into your requirements too closely. If that's the case, you need to always start from the first day of the initial month and first day of the month next to the last month.
If it's not broken, fix it until it is.
My Blog