The information in this article applies to:
- Microsoft Access versions 2.0, 7.0
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
When you use the DateValue() function in a calculated field in a query,
it returns the following error value:
#Error
Or when you use the DateValue() function in Visual Basic for Applications,
you receive the following error message:
In Microsoft Access version 7.0:
Type Mismatch
In Microsoft Access version 2.0:
Illegal function call
CAUSE
The cause depends on your operating system and regional settings:
- In Microsoft Windows 95 or Microsoft Windows NT version 4.0, you set
the Control Panel's Regional Settings, Regional Settings tab to
Finnish and the Time separator to a period (.). There's no need to
reboot to reproduce the problem.
- In Microsoft Windows NT version 3.51, you set the Control Panel's
Country setting to Finland and the Time separator to a period (.).
- In Microsoft Windows version 3.1 and Windows for Workgroups version
3.11, you set the Control Panel's Country setting to Finland, which
automatically sets the Time separator to a period (.).
NOTE: If the Time separator is set to a period and the Control Panel's
Country or Regional Settings is set to Finnish or Finland, all Microsoft
Access Date functions will fail to run whenever the Time portion of a
Date/Time field has a value. However, for this problem to occur in most
cases, you must manually set the Time Separator to a period (.). The Time
separator is automatically set to a period (.) only when you choose Finland
as the Country setting in Windows 3.1 or Windows for Workgroups.
RESOLUTION
Change the Time separator in the Windows Control Panel to a colon (:).
MORE INFORMATION
- In windows 95 or Windows NT version 4.0, in the Control Panel's Regional
Settings dialog box, set the Regional Setting to Finnish and set the
Time separator to a period (.).
In Windows version 3.1 or Windows NT version 3.51, set the Control
Panel's Language setting to Finnish, which automatically sets the Time
separator to a period (.).
- Open the sample database Northwind.mdb (or Nwind.mdb in version 2.0.).
- Open a new module.
- On the View menu, click Debug Window (or Immediate Window in version
2.0).
- Type the following line in the Debug window, and then press Enter:
?DateValue(now)
Note that you receive one of the errors listed in the
|