http://blogs.technet.com/b/heyscriptingguy/archive/2006/07/12/how-can-i-determine-last-month-s-date.aspxHey, Scripting Guy! How can I determine last month’s date? I need to be able to take the month and year for the previous month (using the format mmyy ) and create a file name like this: test0606.xls. -- DR Hey, DR. We have to admit that, at first,en-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/heyscriptingguy/archive/2006/07/12/how-can-i-determine-last-month-s-date.aspx#3480448Mon, 13 Feb 2012 06:18:40 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3480448Gieb<p>&#39; somewhat simpler</p> <p>prevMonthDate = DateAdd(&quot;m&quot;,-1,Date)</p> <p>intMonth = Month(prevMonthDate)</p> <p>intYear = Year(prevMonthDate)</p> <p>intYear = Right(intYear, 2)</p> <p>strFileName = &quot;test&quot; &amp; LEFT(&quot;0&quot; &amp; intMonth,2) &amp; intYear &amp; &quot;.xls&quot;</p> <p>Wscript.Echo strFileName</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3480448" width="1" height="1">http://blogs.technet.com/b/heyscriptingguy/archive/2006/07/12/how-can-i-determine-last-month-s-date.aspx#3391462Thu, 03 Mar 2011 03:25:01 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3391462helfrich2006@comcast.net<p>For some reason, this actually works. &nbsp;Even if you do a 000&amp;Day(date), you get 2 characters. &nbsp;Go figure.</p> <p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;strDay &nbsp;=0&amp;Day(date)</p> <p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;strMon &nbsp;=0&amp;Month(date)</p> <p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;strYear =mid(Year(date),3,2)</p> <p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;strDate = strDay&amp;strMon&amp;strYear</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3391462" width="1" height="1">