Works: Result of the Month() Function Displays as "January" (109046)
The information in this article applies to:
- Microsoft Works 2.0
- Microsoft Works 2.0a
- Microsoft Works 3.0
- Microsoft Works for Windows 95, version 4.0
This article was previously published under Q109046 SUMMARY
The Month function in Works can be used to extract the month number
from a date. However, if the field or cell that contains this result is
formatted as Month Only for the Date format, the result will always
display as "January".
RESOLUTION
Format the cell containing the result as General. In Works 3.0, 4.0, 4.5,
or
4.5a, choose Number from the Format menu and choose General. In Works 2.x,
choose General from the Format menu.
-or-
You can multiply the number Month() returns by 29. This will always display
the correct month.
MORE INFORMATION
The Month function returns a number, 1 for January, 2 for February,
and so on. Because Works sees dates as a serial number representing the
number of days since January 1, 1900, the numbers 1-12 will always be the
first 12 days of January if the cell is formatted as a date.
| Modification Type: | Major | Last Reviewed: | 11/24/2003 |
|---|
| Keywords: | KB109046 |
|---|
|