Summary

Almost any VBA application will sooner or later need to work with date values, and this chapter has provided solid coverage of the built-in date functions, as well as many procedures that use those functions to provide more general functionality. Specifically, we covered these topics:

• How dates are represented in VBA
  
  
• All the built-in date functions:
  • Date, Time, Now
    
    
  • DatePart, WeekDay, Year, Month, Day, Hour, Minute, Second
    
    
  • DateAdd, DateDiff
    
    
  • DateValue, TimeValue, CDate
    
    
  • DateSerial, TimeSerial
    
    
  • Format
• Additional extended functions, for:
  • Finding a specific date
    
    
  • Manipulating dates and times
    
    
  • Working with elapsed time

Given the functions presented in this chapter and the information about writing your own additional functions, you should be ready to handle any date/time challenge facing you in your own applications. For similar chapters covering text and numbers, see Chapters 1 and 3, respectively.

© 1997 by SYBEX Inc. All rights reserved.