Help correcting Date Format

[Jon]

I think I've screwed up my letter trying to fix this. I have merged
information from my database, but the date comes up as 11/29/2007 instead of
November 29, 2007. I've tried to correct his, but then all I get in my merged
letter is DATE. I've seen multiple format options, but I can't figure out how
to fix this. Any help is appreciated.

 

[Graham Mayor]

I think I've screwed up my letter trying to fix this. I have merged
information from my database, but the date comes up as 11/29/2007
instead of November 29, 2007. I've tried to correct his, but then all
I get in my merged letter is DATE. I've seen multiple format options,
but I can't figure out how to fix this. Any help is appreciated.

Change (or add) the formatting switch to the fiield

{Mergefield DATE \@ "MMMM d, yyyy"}

See http://www.gmayor.com/formatting_word_fields.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Jon]

There may be an answer somewhere on that web page, but it eludes me.

 

[Jon]

When I attempt to fix the format and then do a merge instead of getting any
date I get: {DATE \@ "MMMMd,YYYY"}

 

[Doug Robbins - Word MVP]

Assuming that DATE is the name of the field in the data source, what you
need is

{ MERGEFIELD DATE \@ "MMMM dd, yyyy" }

Starting the the Merge Field already in the document, pressing Alt + F9 to
reveal the field codes should result in the following being displayed

{ MERGEFIELD DATE }

The you would add the formatting switch inside the closing field delimiter }

Starting from scratch, you must use Ctrl+F9 to insert the field delimiters
and you use Alt+F9 to toggle off their display.

--
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

 

[Graham Mayor]

The answer was in my reply. The page is a reference on the use of switches
generally.

If instead of a Merge date field you are simply using a date field then the
field should be modified to

{DATE \@ "MMMM d, yyyy"}

If your merge is showing that then either you have not used CTRL+F9 for the
field brackets and thus your field is merely text, or you need to set tools

options > print > uncheck 'Field Codes'.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Jon]

Thanks to both...not quite sure how I got it, but it's working.