Online Resources & Help for Date/Time Functions in Access

Access has a number of built in date and time functions. Figuring out what each does and how to use them to get specific results is often difficult. Here are some links to various resources, mostly at Microsoft web sites, that will help in performing some common date time functions in Access. Many of the links contain code you can copy and paste into your applications.

You may find the following links helpful when dealing with dates in Access.

Dev Avish's The Access Web is great Access resource. The following link takes you to the Date/Time: Index of Articles page.
http://www.mvps.org/access/datetime/index.html

International Dates in Access
http://users.bigpond.net.au/abrowne1/ser-36.html

HOWTO: Write Date Calculation Routines (VBA)
http://support.microsoft.com/default.aspx?kbid=185480

Sample Function to Format Date and Time Intervals (VBA)
http://support.microsoft.com/default.aspx?kbid=186425

Existing Tek-Tips FAQs

faq181-261 - Calculate working days between two dates
faq705-3213 - Calculating a future Workday Date
faq181-1374 - Select birthdays within the next 30 days ...
faq701-3103 - How to determine the First/Last day of a week

Access 20002 (Fewer resources but the Access 2000 code should be apllicable in most cases.)

Two Functions to Calculate Age in Months and Years
http://support.microsoft.com/default.aspx?kbid=290190

Access 2000

Operational Range for Dates in Microsoft Access 2000
http://support.microsoft.com/default.aspx?kbid=240246

Storing, Calculating, and Comparing Date/Time Data
http://support.microsoft.com/default.aspx?kbid=210276

Functions for Calculating and Displaying Date/Time Values
http://support.microsoft.com/default.aspx?kbid=210604

How Windows Regional Settings Affect Microsoft Access
http://support.microsoft.com/default.aspx?kbid=208596

Two Functions to Calculate Age in Months and Years
http://support.microsoft.com/default.aspx?kbid=210522

Convert Short Time Format to Different Formats in Access 2000
http://support.microsoft.com/default.aspx?kbid=210185

Get the Fiscal Year or Month of a Particular Date in Access 2000
http://support.microsoft.com/default.aspx?kbid=210249

Calculating Working Days
http://www.databasejournal.com/features/msaccess/article.php/1552691

Access 97 or earlier

Functions for Calculating and Displaying Date/Time Values
http://support.microsoft.com/default.aspx?kbid=88657

Storing, Calculating, and Comparing Date/Time Data
http://support.microsoft.com/default.aspx?kbid=130514

How Windows Regional Settings Affect Microsoft Access
http://support.microsoft.com/default.aspx?kbid=142009

Two Functions to Calculate Age in Months and Years
http://support.microsoft.com/default.aspx?kbid=100136

You can also download a sample database that contains code demonstrating the functions and code in some of the articles.

ACC2000: Access 2000 Sample Queries
http://support.microsoft.com/default.aspx?kbid=207626

ACC97: Access 97 Sample Queries
http://support.microsoft.com/default.aspx?kbid=182568

Please let me know if any additional resources should be added.