>I was thinking you can do
>
>select count(month(Date))
>group by month(date)
>
>to get the number of months (even partial months).

was thinking along similar lines, but saw no spec that each month will have a date included,
so you are back to min/max aka start and end date...

regards

thomas