Article ID: 937464 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Consider the following scenario. In a Microsoft Visual C++ .NET Framework application, you call the RFX_Date function on a date/time data type field. The field is stored as having a short date/time format in a Microsoft Office Access database. In this scenario, the function returns a value of "December 30, 1899." Additionally, you receive an assertion failure message.
This issue occurs because the date value "December 30, 1899" is out of the range of CTime object dates.
Access stores date/time data type fields as floating-point numbers. The date is represented in the decimal part, and the time is represented in the fractional part. The ranges of date/time data type values in Access are as follows:
To work around this issue, use one of the following methods:
For more information about the RFX_Date function, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/zh-cn/library/9tzyb0fw(vs.80).aspxFor more information about this function, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/114961/ )RFX_Date function for TIMESTAMP_STRUCT