http://snippets.dzone.com/posts Tue, 07 Oct 2008 18:37:03 GMT DZone Snippets: vb code http://snippets.dzone.com/posts/show/5183 'Determines what the next month is based on today and subtracts 1 day from first day of next month. <br /> <br /><code> <br />'VB.NET <br />Dim NextMonth As Integer <br />Dim RptYear As Integer <br />'Determine next month <br />NextMonth = DatePart(DateInterval.Month, DateAdd(DateInterval.Month, +1, today)) <br />'Determine the year of the next month, in case you are going from Dec to Jan <br />RptYear = DatePart(DateInterval.Year, DateAdd(DateInterval.Month, +1, today)) <br />'Subtract 1 day from the first day of next month to get this months last day <br />Return DateAdd(DateInterval.Day, -1, DateValue(NextMonth.ToString & "/1/" & RptYear.ToString)) <br /></code> <br /> Wed, 27 Feb 2008 19:13:47 GMT http://snippets.dzone.com/posts/show/5183 bmowbray (Brian Mowbray)