Microsoft KB Archive/105537

From BetaArchive Wiki

WD: Macro to Determine the Number of Days Between Two Dates

Q105537



The information in this article applies to:


  • Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
  • Microsoft Word for Windows, versions 7.0, 7.0a





SUMMARY

To determine the number of days between two dates, you can convert dates to serial numbers and subtract one number from the other. The DateValue() function converts a specified date, beginning with December 30, 1899, to a serial number.



MORE INFORMATION

WARNING: ANY USE BY YOU OF THE CODE PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this macro code "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

The following WordBasic sample macro prompts for a date in the mm/dd/yy format, and returns the number of days between the current date and the specified date.

The DateValue() function converts a specified date, beginning with December 30, 1899, to a serial number.

Syntax: DateValue(DateText$)

Examples

   x = DateValue("12/30/1899")  ' returns 0 or zero
   x = DateValue("12/31/1899")  ' returns 1
   x = DateValue("12/5/1992")   ' returns 33943 

The Sgn() function is used to determine if the difference between two dates is a negative(date in the past) or positive(date in the future) number.

   Sub MAIN
      On Error GoTo ErrHandler
      ' Prompt for a date.
      otherdate$ = InputBox$("Enter a date in the mm/dd/yy format")
      ' Convert date to serial format.
      serialdate = DateValue(otherdate$)
      ' Get difference between dates.
      numdays = serialdate - Today()
      ' Determine if difference is past or future.
      If Sgn(numdays) = 1 Then
         MsgBox "The number of days between today and " + otherdate$ + \ 
         " is" + Str$(numdays) + "."
      Else
         MsgBox "The date " + enddate$ + " was" + Str$(Abs(numdays)) \ 
         + " days ago."
      End If
      If Err <> 0 Then MsgBox "Please enter a valid date."
   End Sub 

Additional query words: w6macroexample calculate difference

Keywords : kbmacroexample winword word6 word7 word95
Issue type : kbhowto
Technology :


Last Reviewed: November 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.