Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org
FAQs

Terms of Use

Date/Time: Index of Articles

 
 
Calculate Age of a person

Different expressions and functions to correctly calculate a person's age

Return a date in the future from a given date.

How to do basic date calculations

Calculate differences in time

How to do basic date calculations

Return Dates in US #mm/dd/yyyy# format

Work with international date formats 

Calculate Number of Working Days

How to correctly calculate number of work days (not accounting for holidays)

Various Date manipulation functions

Handy functions that return FirstOfMonth, LastOfMonth, NextMonth, LastMonth, and SetDayOfMonth

How to handle midnight in calculations

How to correctly include midnight in date/time calculations

Time, adding and subtracting time and timesheets

How does Access and VBA deal with Date fields and data type

Determining Average Time

How to calculate Average Time by using two queries

How many Sundays between two dates

How to calculate the number a specific day appears in an interval

Doing WorkDay Math in VBA

Code from "Visual Basic Language Developer's Handbook" for information on the next and previous workdays, finding the first and last workday in a month, and deal with Holidays


1998-2002, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer