>>Is there a function that returns the number of days in a month?
>>example...
>>jan has 31 days
>>days_in_a_month = (some_function,jan)
>>?days_in_a_month
>>31....any ideas?
>
>Nope but try
>
>** gets number of days in given month
>ldDate = DATE() && or whatever
>ldFirst = DATE(YEAR(ldDate), MONTH(ldDate), 1)
>lnDaysInMonth = GOMONTH(ldFirst,1)-ldFirst

Actually, you don't need the first 2 lines,
IOW

lnDaysInMonth = GOMONTH(ldDate,1)-ldDate