Works: Use MONTH Function When Querying for Months in Database (125316)
The information in this article applies to:
- Microsoft Works for Windows 95, version 4.0
- Microsoft Works for Windows 95, version 4.0 4.5
- Microsoft Works for Windows 95, version 4.0 4.5a
- Microsoft Works 2.0
- Microsoft Works 2.0a
- Microsoft Works 3.0
- Microsoft Works 3.0a
- Microsoft Works 3.0b
This article was previously published under Q125316 SUMMARY
In the Works for Windows Database module, querying for dates that fall
in a particular month can be done with the MONTH() function.
NOTE: In Works 4.0, 4.5, or 4.5a, these filters must be created using the Filter Using Formula option. In Works 3.0x, these queries must be entered in the Query view of the Database.
The MONTH() function will return an integer from 1 to 12 specifying the
month of the given date. For instance, the following formula will bring up
all records which have the month of May in the BirthDate field.
REFERENCES
"Microsoft Works for Windows User's Guide" (version 3.0), page 547,
Appendix A: "Spreadsheet and Database Functions."
"Microsoft Works for Windows User's Guide" (version 3.0), page 369 for
information about using AND and OR operators.
"Microsoft Works for Windows User's Guide" (version 2.0), page 278 for
information about using AND and OR operators.
Modification Type: | Major | Last Reviewed: | 11/15/2004 |
---|
Keywords: | kbinfo KB125316 |
---|
|