date formatting

[joe]

I am not able to get date formatting to work in an Office
2003 mail merge document. I am using the following form
of switch: { MERGEFIELD RentalDate \@ "MMMM d, yyyy" }
I have tried every combination of adding the switch to
the mail merge field....what am I doing wrong? HELP!

 

[Cindy M -WordMVP-]

Hi Joe,

I am not able to get date formatting to work in an Office
2003 mail merge document. I am using the following form
of switch: { MERGEFIELD RentalDate \@ "MMMM d, yyyy" }
I have tried every combination of adding the switch to
the mail merge field....what am I doing wrong?

OK, Word 2003...

What's the data source?

How does the mergefield data appear with NO switch? And what
do you see with the switch?

After adding the switch have you explicitly forced the field
to update its display (click in it and press F9)?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Charles Kenyon]

Take a look at the thread with a subject "Date format" started on 12/2.
Cindy Meister posted the following suggestion which works fine:

{ Quote "{ = { Mergefield Date } \# "0000'-'00'-'00" }" \@ "MMMM d, yyyy" }

The source date is formatted yyyyMMdd.
--

Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.