Date (data type)

Syntax Date
Description A data type capable of holding date and time values.
Comments Date variables are used to hold dates within the following range:
  January 1, 100 00:00:00 <= date <= December 31, 9999 23:59:59
  –6574340 <= date <= 2958465.99998843
Internally, dates are stored as 8-byte IEEE double values. The integer part holds the number of days since December 31, 1899, and the fractional part holds the number of seconds as a fraction of the day. For example, the number 32874.5 represents January 1, 1990 at 12:00:00. When appearing within a structure, dates require 8 bytes of storage. Similarly, when used with binary or random files, 8 bytes of storage are required. There is no type-declaration character for Date .
Date variables that haven't been assigned are given an initial value of 0 (i.e., December 31, 1899).
Date Literals Literal dates are specified using number signs, as shown below:
  Dim d As Date
  d = #January 1, 1990#
The interpretation of the date string (i.e., January 1, 1990 in the above example) occurs at runtime, using the current country settings. This is a problem when interpreting dates such as 1/2/1990. If the date format is M/D/Y, then this date is January 2, 1990. If the date format is D/M/Y, then this date is February 1, 1990. To remove any ambiguity when interpreting dates, use the universal date format:  date_variable = #YY/MM/DD HH:MM:SS# The following example specifies the date June 3, 1965 using the universal date format:
  Dim d As Date
  d = #1965/6/3 10:23:45#
See Also Currency (data type); Double (data type); Integer (data type); Long (data type); Object (data type); Single (data type); String (data type); Variant (data type); Boolean (data type); DefType (statement); CDate, CVDate (functions).