>>>lnDaysInMonth = GOMONTH(ldDate,1)-ldDate
>>-------------
>>works great...thanks everybody....:)))
>

---

>Nope. It doesn't work properly for January 30-31 in particular.
>

Yeah, yeah, yeah :) I caught this a little bit after I posted it, and replied to myself with the fix.
I like yours better, though. <g>

Yep - doesn't work for any date where the next month doesn't have that date. Like Jan 29-31 (in non-leap years), October 31, etc.

>Below is corrected version
>
>lnDaysInMonth = GOMONTH(ldDate-Day(ldDate)+1,1)-1

BTW, that gets the last day of the month, not the number of days.

lnDaysInMonth = DAY(GOMONTH(ldDate-Day(ldDate)+1,1)-1)

gets # of days.