Working with Dates and Times

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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.