PRB: 12/30/1899 Appears as a Blank Date in Microsoft Access (150433)
The information in this article applies to:
- Microsoft ODBC Driver for Visual FoxPro 1.0
This article was previously published under Q150433 SYMPTOMS
If 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.
CAUSE
The 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".
STATUS
This behavior is by design.
Modification Type: | Major | Last Reviewed: | 6/17/1999 |
---|
Keywords: | kbinterop kbprb KB150433 |
---|
|