http://blogs.technet.com/b/heyscriptingguy/archive/2005/08/11/how-can-i-determine-the-beginning-and-ending-date-of-the-previous-month.aspxHey, Scripting Guy! Given a specific date, how can I determine the beginning and ending date of the previous month? In other words, given 8/11/2005, I need to get back 7/1/2005 and 7/31/2005. -- PH Hey, PH. You know, this was a tough question for usen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/heyscriptingguy/archive/2005/08/11/how-can-i-determine-the-beginning-and-ending-date-of-the-previous-month.aspx#3387426Tue, 15 Feb 2011 14:19:39 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3387426Israel Valencia<p>Cool!</p> <p>I liked your solution. Although for the first day of month I modified a bit and used:</p> <p>val = now - Day(now) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </p> <p>val = dateserial(year(val), month(val), 1)</p> <p>This way you get a date variable because if you are using a computer with regional settings for date format different to mmddyyyy you would get the month in the place of the day or any other order combination you were not expecting :)</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3387426" width="1" height="1">