Reply
 
Thread Tools Display Modes
  #1   Report Post  
gb_S49
 
Posts: n/a
Default Date format frustration

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}
  #2   Report Post  
gb_S49
 
Posts: n/a
Default


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)
  #3   Report Post  
Graham Mayor
 
Posts: n/a
Default

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



  #4   Report Post  
Charles Kenyon
 
Posts: n/a
Default

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}



  #5   Report Post  
Charles Kenyon
 
Posts: n/a
Default

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







  #6   Report Post  
gb_S49
 
Posts: n/a
Default

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




  #7   Report Post  
Graham Mayor
 
Posts: n/a
Default

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



  #8   Report Post  
Poolshark
 
Posts: n/a
Default

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}

  #9   Report Post  
Posted to microsoft.public.word.mailmerge.fields
steve roper
 
Posts: n/a
Default Date format frustration

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}

  #10   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Marco Marco is offline
external usenet poster
 
Posts: 6
Default Date format frustration

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}



  #11   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Marco Marco is offline
external usenet poster
 
Posts: 6
Default Date format frustration

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}

  #12   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Date format frustration

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}


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
date format change when using serial printing Paulo Merieles Microsoft Word Help 3 January 5th 05 12:24 AM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 07:34 AM
date format problem in access 2002 jay Tables 1 December 13th 04 08:18 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM
Why does the date format change when I mail merge from Access? Alex Mailmerge 1 December 6th 04 02:25 PM


All times are GMT +1. The time now is 05:41 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"