I am trying to complete a mail merge sourced from excel and keep getting the
american date format (MM/DD/YY. despite my efforts I am unable to affect a
change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}

I am trying to complete a mail merge sourced from excel and keep getting the
american date format (MM/DD/YY. despite my efforts I am unable to affect a
change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}
I am trying to get UK date (DD/MM/YY)

gb_S49 wrote:
I am trying to complete a mail merge sourced from excel and keep
getting the american date format (MM/DD/YY. despite my efforts I am
unable to affect a change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}
I am trying to get UK date (DD/MM/YY)

Your syntax is wrong - try
{Mergefield Date_Joined_Company \@ "dd/mm/yy"}

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

--

Graham Mayor - Word MVP

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

See http://addbalance.com/word/datefields1.htm for information on the
different kinds of datefields and how to format them. While this is about
the CREATEDATE and DATE fields, the formatting pictures work for mergefields
as well if your date data is in standard date format.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

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

See also the MVP FAQ: 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.
"gb_S49" wrote in message
...
I am trying to complete a mail merge sourced from excel and keep getting
the
american date format (MM/DD/YY. despite my efforts I am unable to affect a
change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}

Not sure about merge fields, but on date and time fields generally, the "M"
in the picture is case-sensitive, in that upper case gives a month while
lower case gives minutes.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

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

See also the MVP FAQ: 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.

"Graham Mayor" wrote in message
...
gb_S49 wrote:
I am trying to complete a mail merge sourced from excel and keep
getting the american date format (MM/DD/YY. despite my efforts I am
unable to affect a change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}
I am trying to get UK date (DD/MM/YY)

Your syntax is wrong - try
{Mergefield Date_Joined_Company \@ "dd/mm/yy"}

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

--

Graham Mayor - Word MVP

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

Well spotted
Thanks Graham

"Graham Mayor" wrote:

gb_S49 wrote:
I am trying to complete a mail merge sourced from excel and keep
getting the american date format (MM/DD/YY. despite my efforts I am
unable to affect a change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}
I am trying to get UK date (DD/MM/YY)

Your syntax is wrong - try
{Mergefield Date_Joined_Company \@ "dd/mm/yy"}

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

--

Graham Mayor - Word MVP

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

Oops - you are right - a senior moment

Let's change that for

{Mergefield Date_Joined_Company \@ "dd/MM/yy"}

--

Graham Mayor - Word MVP

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




Charles Kenyon wrote:
Not sure about merge fields, but on date and time fields generally,
the "M" in the picture is case-sensitive, in that upper case gives a
month while lower case gives minutes.

"Graham Mayor" wrote in message
...
gb_S49 wrote:
I am trying to complete a mail merge sourced from excel and keep
getting the american date format (MM/DD/YY. despite my efforts I am
unable to affect a change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}
I am trying to get UK date (DD/MM/YY)

Your syntax is wrong - try
{Mergefield Date_Joined_Company \@ "dd/mm/yy"}

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

--

Graham Mayor - Word MVP

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

Go to Start: Settings: Control Panel: Regional & Language Options, Then go
into the Regional Options tab: click on customize (beside English) click on
date tab: In the box for (Short date format):type in mm/dd/yyyy. That should
solve your problem.
"gb_S49" wrote:

I am trying to complete a mail merge sourced from excel and keep getting the
american date format (MM/DD/YY. despite my efforts I am unable to affect a
change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}

This helped me and worked fine with same problem

"gb_S49" wrote:

I am trying to complete a mail merge sourced from excel and keep getting the
american date format (MM/DD/YY. despite my efforts I am unable to affect a
change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}

[Marco]

Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but
then after the mail merge it appears has 01/17/2006.

I tried to format, I change to toogle and format as you told me, I get this
filead:
{Mergefield Data \@ "dd/mm/yyyy" } and this result: 17/00/2006

Why the months apears as zeros?

I even tried to change in Regional Setting the short date to dd/mm/aa but
nothing.

The best that I could get was making a trick. After all register in Excel, I
insert another register and I put some text into the date column.

Any ideas?

Regards,
Marco




"steve roper" wrote:

This helped me and worked fine with same problem

"gb_S49" wrote:

I am trying to complete a mail merge sourced from excel and keep getting the
american date format (MM/DD/YY. despite my efforts I am unable to affect a
change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}

[Marco]

Hi. I already find out my problem. I wasn't using M in upper case. I was
using mm.

Marco

"Marco" wrote:

Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but
then after the mail merge it appears has 01/17/2006.

I tried to format, I change to toogle and format as you told me, I get this
filead:
{Mergefield Data \@ "dd/mm/yyyy" } and this result: 17/00/2006

Why the months apears as zeros?

I even tried to change in Regional Setting the short date to dd/mm/aa but
nothing.

The best that I could get was making a trick. After all register in Excel, I
insert another register and I put some text into the date column.

Any ideas?

Regards,
Marco




"steve roper" wrote:

This helped me and worked fine with same problem

"gb_S49" wrote:

I am trying to complete a mail merge sourced from excel and keep getting the
american date format (MM/DD/YY. despite my efforts I am unable to affect a
change. All suggestions greatfully received
{mergefield "Date_Joined_Company"/"dd/mm/yy}

[macropod]

Hi Marco,

Lowercase ms are for minutes - uppercase Ms for months.

Try:
{Mergefield Data \@ "dd/MM/yyyy" }

Cheers
--
macropod
[MVP - Microsoft Word]


"Marco" wrote in message ...
| Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but
| then after the mail merge it appears has 01/17/2006.
|
| I tried to format, I change to toogle and format as you told me, I get this
| filead:
| {Mergefield Data \@ "dd/mm/yyyy" } and this result: 17/00/2006
|
| Why the months apears as zeros?
|
| I even tried to change in Regional Setting the short date to dd/mm/aa but
| nothing.
|
| The best that I could get was making a trick. After all register in Excel, I
| insert another register and I put some text into the date column.
|
| Any ideas?
|
| Regards,
| Marco
|
|
|
|
| "steve roper" wrote:
|
| This helped me and worked fine with same problem
|
| "gb_S49" wrote:
|
| I am trying to complete a mail merge sourced from excel and keep getting the
| american date format (MM/DD/YY. despite my efforts I am unable to affect a
| change. All suggestions greatfully received
| {mergefield "Date_Joined_Company"/"dd/mm/yy}