Here are some of the articles relating to manipulating date and time. At the top of each article you will see which collection (gold, silver or bronze) the article belongs to.

About Time

Date Tricks

Fuzzy Dates

When DateAdd Doesn't

Did Someone Say Holiday

Access Developer Needs a Date

Working All Day - Weekends

 

The full collections and related download files can be purchased here.