Help correcting Date Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jon - 29 Nov 2007 14:56 GMT

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.

Reply to this Message

Graham Mayor - 29 Nov 2007 15:16 GMT

> 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

Signature

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

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

Reply to this Message

Jon - 29 Nov 2007 15:27 GMT

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

> > 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
[quoted text clipped - 7 lines]
>
> See http://www.gmayor.com/formatting_word_fields.htm

Reply to this Message

Jon - 29 Nov 2007 15:34 GMT

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

> There may be an answer somewhere on that web page, but it eludes me.
>
[quoted text clipped - 9 lines]
> >
> > See http://www.gmayor.com/formatting_word_fields.htm

Reply to this Message

Doug Robbins - Word MVP - 29 Nov 2007 19:08 GMT

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.

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

> When I attempt to fix the format and then do a merge instead of getting
> any
[quoted text clipped - 13 lines]
>> >
>> > See http://www.gmayor.com/formatting_word_fields.htm

Reply to this Message

Graham Mayor - 30 Nov 2007 06:04 GMT

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

Signature

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

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

> There may be an answer somewhere on that web page, but it eludes me.
>
[quoted text clipped - 18 lines]
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Reply to this Message

Jon - 03 Dec 2007 15:18 GMT

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

> The answer was in my reply. The page is a reference on the use of switches
> generally.
[quoted text clipped - 30 lines]
> >> Word MVP web site http://word.mvps.org
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Reply to this Message