Looking for help to change the format of a text string...mailmerge source is
a .csv file, with date formatted as "dd-MMM-yy". I would really like to
convert this to a standard "MM/dd/yyyy" format.

A similar item was addressed by Peter on 08/05/05 (Merge Field Formatting),
but I have been unable to apply his solution to my problem due to the
different date format.

I've tried the following, but was unsuccessful:

{QUOTE { MERGEFIELD Date1 \# "00-@@@-00" } \@ MM/dd/yyyy }

Any help would be greatly appreciated

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindy...r/MergFram.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
"aiyou" wrote in message
...
Looking for help to change the format of a text string...mailmerge source
is
a .csv file, with date formatted as "dd-MMM-yy". I would really like to
convert this to a standard "MM/dd/yyyy" format.

A similar item was addressed by Peter on 08/05/05 (Merge Field
Formatting),
but I have been unable to apply his solution to my problem due to the
different date format.

I've tried the following, but was unsuccessful:

{QUOTE { MERGEFIELD Date1 \# "00-@@@-00" } \@ MM/dd/yyyy }

Any help would be greatly appreciated

{Mergefield Date1 \@ "MM/dd/yyyy"} should work.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


aiyou wrote:
Looking for help to change the format of a text string...mailmerge
source is a .csv file, with date formatted as "dd-MMM-yy". I would
really like to convert this to a standard "MM/dd/yyyy" format.

A similar item was addressed by Peter on 08/05/05 (Merge Field
Formatting), but I have been unable to apply his solution to my
problem due to the different date format.

I've tried the following, but was unsuccessful:

{QUOTE { MERGEFIELD Date1 \# "00-@@@-00" } \@ MM/dd/yyyy }

Any help would be greatly appreciated