Microsoft Office 2000/Visual Basic Programmer's Guide

Working with Dates and Times

VBA provides a data type for storing date and time values, the Date data type. Convenient as the Date data type is, manipulating date values in VBA can still be tricky. To easily work with dates, you need to understand how VBA stores date values internally.

Note   The Microsoft Office 2000 applications all support dates beyond the year 2000. However, there are some issues you need to take into account in order to design your application so that it properly handles both twentieth and twenty-first century dates. An extensive discussion of these issues is available on the Microsoft Year 2000 Resource Center Web site at http://www.microsoft.com/technet/topics/year2k/default.htm.