¨ FrontPage ¨ Outlook ¨
¨ Miscellaneous ¨
Hopefully, this article will help to settle some confusion about date fields. I continually see questions about it in the newsgroups and on forums.
The day the document was created.
If you want a document that's created from a template to show today's date, and always today's date—so if you create the document on June 24, 2005 and you open it in August, it'll still say June 24, 2005, you can use InsertàField, choose Date and Time and choose Create Date.
InsertàDate and Time, choose your format, and make sure Automatically Update is not checked.
Use the date the document is printed. This is good for mail merges and documents that you regularly update, such as a report.
InsertàField, choose Date and Time, and choose Print Date.
There are other date fields in Word from which you can choose. Check them out.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved