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.
Important! Selecting a language below will dynamically change the complete page content to that language.
Version:
0511
Date Published:
6/5/2011
File Name:
AccessDateFunctions_CODE.zip
File Size:
26.4 KB
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.Supported 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:
- 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.
- This package does not collect any personal information.