Developer

Murray Brown

<div>
For date calculations, you may like to review<br />
<br />
<a href="http://www.theaccessweb.com/datetime/date0007.htm" rel="ugc">http://www.theaccessweb.co<wbr />m/datetime<wbr />/date0007.<wbr />htm</a><br />
<a href="https://utteraccess.com/wiki/Category:DateTime_Functions" rel="ugc">https://utteraccess.com/wi<wbr />ki/Categor<wbr />y:DateTime<wbr />_Functions<wbr /></a><br />
<a href="http://www.utteraccess.com/forum/index.php?showtopic=321493" rel="ugc">http://www.utteraccess.com<wbr />/forum/ind<wbr />ex.php?sho<wbr />wtopic=321<wbr />493</a>
</div>


For date calculations, you may like to review

http://www.theaccessweb.com/datetime/date0007.htm [http://www.theaccessweb.com/datetime/date0007.htm]
https://utteraccess.com/wiki/Category:DateTime_Functions [https://utteraccess.com/wiki/Category:DateTime_Functions]
http://www.utteraccess.com/forum/index.php?showtopic=321493 [http://www.utteraccess.com/forum/index.php?showtopic=321493]

<div>
You're welcome! Glad I was of help :)
</div>


<div>
<div class="content wysiwyg-content">
Hi. &nbsp;If the following code finds the start and end of last year, what similar code doI use to find the start and end of last month<br />
<br />
txtStartDate = DateSerial(Year(Date) - 1, 1, 1)<br />
txtEndDate = DateSerial(Year(Date) - 1, 12, 31)
</div>
</div>


Hi.  If the following code finds the start and end of last year, what similar code doI use to find the start and end of last month

txtStartDate = DateSerial(Year(Date) - 1, 1, 1)
txtEndDate = DateSerial(Year(Date) - 1, 12, 31)

Access VBA Get dates for last month

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.