Microsoft KB Archive/106290

= ACC: Using Format and Month Returns Incorrect Month =

Article ID: 106290

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



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.



MORE INFORMATION
The following sample function returns January instead of April:

  =Format$(Month(#4/30/93#), "mmmm")

To return just the name of the month, use the Format function without the Month function. For example, the following expression returns April:

  =Format(#4/30/93#,"mmmm")

If the Month function is required, use the Choose function to return the name of the month. The following example demonstrates how to use the Choose function:

NOTE: In the following example, an underscore (_) is used as a line- continuation character. Remove the underscore from the end of the line when re-creating the example.

  =Choose(Month([datefield]),"January","February","March","April", _

"May","June","July","August","September","October","November", _ "December")

