>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only