Works: Result of the Month() Function Displays as "January"
Article ID: 109046
Article Last Modified on 11/24/2003
APPLIES TO
- Microsoft Works 2.0 Standard Edition
- Microsoft Works 2.0a
- Microsoft Works 3.0 Standard Edition
- Microsoft Works 4.0 Standard Edition
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.
Additional query words: swept_45a_Upd: rickvi
Keywords: KB109046