WD: TimeValue() Function Returns Incorrect Time Value

 Last reviewed: February 3, 1998
Article ID: Q117699
The information in this article applies to:
  • Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
  • Microsoft Word for Windows NT, version 6.0
  • Microsoft Word for Windows 95, versions 7.0, 7.0a
  • Word for the Macintosh, versions 6.0, 6.0.1

SYMPTOMS

The TimeValue macro function ignores the "p" in "2:04 p" and returns a serial number for "2:04 am" instead.

CAUSE

The times listed below all refer to the same time, 2:04 in the afternoon. 

   2:04 pm
   2:04 PM
   2:04 p
   2:04 P
When the values "p" or "P" are passed to the WordBasic TimeValue() function, TimeValue() fails to recognize them as being valid notations for "pm". It instead ignores the "p" and treats the value as a morning time value--that is, "am."

WORKAROUND

Use "PM", "pm", "AM" or "am" instead of "P", "p", "A" or "a" when passing values to the TimeValue() function.

STATUS

Microsoft has confirmed this to be a problem in the Word versions listed in the Applies To section of this article. This problem has been corrected in Word 97 for Windows and Word 98 Macintosh Edition.

Additional query words: time value
Keywords : macword ntword word6 word7 word95 wordnt kbcode kbmacro kbprg
Version : WINDOWS:6.0,6.0a,6.0c,7.0,7.0a; MACINTOSH:6.0,6.0.1,6.0.1a
Platform : MACINTOSH WINDOWS
Issue type : kbbug
Solution Type : kbfix kbworkaround

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.

Last reviewed: February 3, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.