Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
I have a field of DATE in data source file entered as 051025 to mean yyMMdd.
How do I format the field in main document to show the date as 2005-10-25 or 2005/10/25 ? Thanks. |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
I don't think that it is possible to do that using formatting switches on
the field. This means that you would either have to do modify the data source, or after executing the merge to a new document, do a wildcard Find and Replace where you search for ([0-9]{2})([0-9]{2})([0-9]{2}) and replace that with 20\1/\2/\3 To learn about use a wildcard search, see the article "Finding and replacing characters using wildcards" at: http://www.word.mvps.org/FAQs/Genera...gWildcards.htm -- 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 "LS" wrote in message ... I have a field of DATE in data source file entered as 051025 to mean yyMMdd. How do I format the field in main document to show the date as 2005-10-25 or 2005/10/25 ? Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I omit an empty date merge field? | Microsoft Word Help | |||
using date field in merge | Mailmerge | |||
How to prevent Merged Date Field showing time? | Mailmerge | |||
inserting a date field for a future date | Microsoft Word Help | |||
Date issue merging from Excel field in Date format to Word | Mailmerge |