INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Functions

Online Resources & Help for Date/Time Functions in Access by tlbroadbent
Posted: 7 Mar 03 (Edited 8 Mar 03)

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.

Back to Microsoft: Access Modules (VBA Coding) FAQ Index
Back to Microsoft: Access Modules (VBA Coding) Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close