>Hi All,
>
>Is there a function to calculate number of days per month per
>year. Need to figure if Feb is 29 or 28 days for instance.
>
>Thanks
>
>Doron
ldDate = DATE() &&Substitute the date you want
ldLastDayOfMonth = DAY(GOMONTH(DATE(YEAR(ldDate), MONTH(ldDate), 1), 1) - 1)
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer