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

  • Published:
  • Version: 0511
  • Category: SDK
  • Language: English

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.


Status: Live

This download is still available on The downloads below will come directly from the Microsoft Download Center.

FileSHA1 HashSize
AccessDateFunctions_CODE.zip2f0f62e85f3b2a82bbdf004102a56eda799bc37026 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

Installation Instructions

  • To install this download:
    1. Download the file by clicking the Download link (above) and saving the file to your hard disk drive.
    2. Double-click the program file on your hard disk drive to extract the named AccessDateFunctions.accdb.

Related Resources