InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumWed, 10 Jun 2026 22:40:41 GMT20http://forum.strataframe.net/FindPost5844.aspxHere's how I am determining the first and last day of the previous month.<br> <br> Me.tbdtpStartDate.EditValue = DateSerial(Year(Now()), Month(Now()) - 1, 1)<br> Me.tbdtpEndDate.EditValue = DateSerial(Year(Now()), Month(Now()), 0)<br> <br> It seems to me there should be a more elegant way in VB .NET. Does anybody know of one?<br>Tue, 16 Jan 2007 12:04:34 GMTStarkMikehttp://forum.strataframe.net/FindPost5876.aspxYeah, but you could write a helper method that would encapsulate it ;)Tue, 16 Jan 2007 12:04:34 GMTStrataFrame Teamhttp://forum.strataframe.net/FindPost5855.aspxThanks Ben. Too bad I couldnt go Now.PreviousMonth</P><P>;)Tue, 16 Jan 2007 10:00:52 GMTStarkMikehttp://forum.strataframe.net/FindPost5854.aspxYou can do it the more .NET way like this:</P><P>Dim n As DateTime = DateTime.Now<BR>Me.tbdtpStartDate.EditValue = New DateTime(n.Year, n.Month - 1, 1)<BR>Me.tbdtpEndDate.EditValue = New DateTime(n.Year, n.Month - 1, DateTime.DaysInMonth(n.Year, n.Month - 1))Tue, 16 Jan 2007 09:57:25 GMTStrataFrame Team