PRB: 12/30/1899 Appears as a Blank Date in Microsoft AccessLast reviewed: March 20, 1998Article ID: Q150433 |
The information in this article applies to:
SYMPTOMSIf a Visual FoxPro date field contains a value 12/30/1899, then it will display as 12:00:00AM, a blank date, in Microsoft Access.
CAUSEThe FoxPro ODBC driver returns 0 for an empty date instead of NULL. In Microsoft Access and any other VBA/DAO product, dates and times are stored as the number of days since 12/30/1899, which is day 0, and time values are stored as fractions of a day. The default formatting for date/time data is:
Data Display ---- ------- 3.0 date only: 1/2/1901 3.25 date and time: 1/2/1901 6:00:00AM 0.25 time only: 6:00:00AM 0.0 time only: 12:00:00AM NULL blank:As you can see, the 0.0 case is a special case of "time only".
STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
|
Additional query words: 1.00 VFoxWin
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |