2.5.65 DateAsNum
The DateAsNum structure specifies a date and time value stored as an Xnum (section 2.5.342).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
dateNum |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
dateNum (8 bytes): An Xnum that specifies a date and time value. The value uses the double-precision floating point number in the Xnum structure as follows: The integer part of the number specifies the date as a number of days from a base date<162>, and the fractional part specifies the time of day as a fraction of a 24-hour day. The base date for the number of days is determined by the date system used in the workbook, as specified by the Date1904 record in the Globals Substream, according to the following table:
|
Date system |
Meaning |
|---|---|
|
1900 |
A value of 1 to dateNum specifies 00:00:00 on January 1, 1900. |
|
1904 |
A value of 0 to dateNum specifies 00:00:00 on January 1, 1904. |