Date format in Message

[Barb R.]

lastMod = ActiveDocument.CustomDocumentProperties("ModificationDate").Value

If MsgBox("The document modification date is " & lastMod & _
". Do you want to change" & " the document modification date
to today's date?", vbYesNo) = vbYes Then
ActiveDocument.CustomDocumentProperties("ModificationDate").Value =
Date

....
The date is shown with both Date/Time, but I want it to be displayed as a
date only. What do I need to do to get the desired format?
ModificationDate is a Custom Property of the document and is in DATE format.

Thanks in advance

Barb Reinhardt

 

[Doug Robbins]

Use the Format() function

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Barb R.]

That works! Thanks.

Use the Format() function

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP