PRB: Weekday() Function Ignores First Weekday OptionArticle ID: Q120974Creation Date: 23-SEP-1994 Revision Date: 19-SEP-1996
The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
When you set the First Weekday option to any day other than the default day
of Sunday, the Weekday() function ignores the option setting and returns
the default values for the days of the week.
RESOLUTION
The Microsoft Access version 2.0 "Language Reference" manual, in the
"Weekday Function" topic on pages 654-655, should state that you must use 0
(zero) as the first argument for the Weekday() function in order to allow
the function to recognize the First Weekday option setting.
This information is documented correctly in the "Weekday Function" topic in
the Microsoft Access Help system.
REFERENCES
Microsoft Access "Language Reference," version 2.0, pages 654-655
|
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.