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.
    • Version:


      File Name:

      Date Published:


      File Size:

      27 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 System

      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
      • 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.

      • This package does not collect any personal information.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Office 365 on the devices you love. Buy now.
    The Office you love, on the devices you love
    Includes PC, Mac, smartphone, and tablet—starting at $6.99/month.
    Buy and download