WD: TimeValue() Function Returns Incorrect Time Value

ID: Q117699

The information in this article applies to:

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          : kbmacro kbprg kbdtacode wordnt ntword macword word6 word7 word95 
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

Last Reviewed: March 27, 1998