MVP Centre
Welcome to the MVP Centre. This page is the portal to a wealth of
information about Microsoft Access.
Date & Time
You are free to copy and use any of the samples supplied on this website for
use in your own projects, provided that all copyright notices remain intact as
part of the code. You may not publish the code to any website or other medium
without the express written permission of the copyright holder. Each sample is
provided on an "as is" basis. No warranty is expressed or implied, and no
support is offered.
| Diff2Dates |
An accurate DateDiff
function for determining the difference between two dates/times. |
| DiffTime |
An accurate DateDiff
function for determining the time difference between two dates/times.
|
| AgeYMD |
An accurate age
calculator. |
| Date2Text |
Function to convert
a date to its textual representation. |
|
Validate dates & times |
Validate date & time
formats using Regular Expressions. |
|
Day functions |
Functions for
calculating specific days, day names, next Friday, and so on. |
|
Week functions |
Functions for
calculating specific weeks of the month/year, first/last day of the
previous/current/next week, and so on. |
|
Month functions |
Functions for
calculating specific months, first/last working day of the month, last
Friday in the month, number of specific days in a month, and so on.
|
|
Quarter functions |
Functions for
calculating specific quarters, first/last day of the quarter, first
Friday in a quarter, and so on. |
|
Year functions |
Functions for
calculating specific years, 27th day of the year, leap years, and so on.
|
|
Weekday functions |
Functions for
calculating specific weekdays, first weekday of the month/year, first
weekday after a specific date, and so on. |
|
Duration functions |
Functions for
calculating the number of years/months/weeks/weekdays/days between two
dates, and so on. |
|
Date functions |
Functions for
calculating n days/weeks/months from a specific date, and so on. |
|
Milestone functions |
Functions for
calculating milestones: Leap-year, Weekday, Weekend, and so on. |
|
Easter functions |
Functions for
calculating Good Friday, Easter Saturday/Sunday, and so on. |
| |
|
| |
|
|
|
|
|
