>>>I need a function or 'select statemt' that can calculate the no. of distinct days in a month. For example, I would like the fn to calculate the total no of Sundays or any of the other 6 days in January. Preferably there is to be no keying of dates. Thanks in advance.
>>
>>function DaysInMonth( tdDateInMonth )
>>local ldDayNextMonth
>>ldDayNextMonth = gomonth(tdDateInMonth, 1)
>>return day(ldDayNextMonth - day(ldDayNextMonth))
>>
>>I'm sure that some one will post an even shorter one.
>
>OOPS! :))

Maybe I'll read the posts better when I'm not drinking? At least the function does what I wrote it to do well.