Microsoft Download Center Archive
 | ODC: Visual How-to Sample: How to Find the First and Last Day in a Given Week, Month, or Year in Access 2010 |
Access 2010, along with VBA, makes it easy to find specific days in a given week, month, or year.
- You can use Visual Basic for Applications (VBA) to create functions that return the first and last day in a given week, month, or year. You can specify a date for the calculation, or you can pass no parameter to indicate the current date.The date functions built into VBA make it easy to perform calculations based on date arithmetic. Whether you must calculate the first or last day in a given week, month, or year, you can easily get the value that you want.
Files
 | Status: LiveThis download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center. |
| File | Size |
|---|---|
 AccessDateFunctions_CODE.zipSHA1: 2f0f62e85f3b2a82bbdf004102a56eda799bc370 | 26 KB |
File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.
System Requirements
Operating Systems: Windows 7, Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista Service Pack 1, Windows XP Service Pack 3
- This download works with the following Office applications:
- Microsoft Access 2010
- Microsoft Office Access 2007
- This download works with the following Office applications:
Installation Instructions
- To install this download:
- Download the file by clicking the Download link (above) and saving the file to your hard disk drive.
- Double-click the AccessDateFunctions_CODE.zip program file on your hard disk drive to extract the named AccessDateFunctions.accdb.