Formatting Text String (dd-MMM-yy) to Date (MM/dd/yyyy)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aiyou - 25 Aug 2005 19:01 GMT

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

Reply to this Message

Doug Robbins - 26 Aug 2005 05:52 GMT

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/cindymeister/MergFram.htm

Signature

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

> Looking for help to change the format of a text string...mailmerge source
> is
[quoted text clipped - 11 lines]
>
> Any help would be greatly appreciated

Reply to this Message

Graham Mayor - 26 Aug 2005 06:18 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> 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
[quoted text clipped - 9 lines]
>
> Any help would be greatly appreciated

Reply to this Message