View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Format the field of DATE

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.