ACC: Using Format() and Month() Returns Incorrect Month (106290)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q106290
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
If you use the Format() function on the result of a Month() function,
Microsoft Access returns an incorrect result.
CAUSE
The Month() function converts a date to an integer. The Format() function
is expecting a date serial number as an argument, but instead receives an
integer.
STATUS
This behavior is by design.
REFERENCES
For information about syntax and usage of the Choose function, search the
Help Index for "Choose function."
Modification Type: | Major | Last Reviewed: | 5/6/2003 |
---|
Keywords: | kbprb KB106290 |
---|
|