>>>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
You do need those two lines, because if you're on Jan 31st, gomo(jan31,1) will give you February 29th (assume a leap year), and {feb 29}-{jan 31} would give you 29 instead of 31. Therefore, it's only safe to go back to 1st day of the month first.