Mail Merge Date fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fi - 05 Jun 2007 15:38 GMT

I have an excel datasource with dates formatted to show e.g. 5th June 2007.

However when I merge the datasource in Word and insert the date field it
shows as 06/05/2007.

I am using Office 2003 on XP. My regional settings are set to UK. Is this
common to set the date to American format. Is there a way to edit the mail
merge field format to show the correct date format?

Reply to this Message

Peter Jamieson - 05 Jun 2007 15:54 GMT

> Is this
> common to set the date to American format.

It is certainly what usually happens in this particular case.

In this case you should be able to change a mergefield such as

{ MERGEFIELD mydate }
to
{ MERGEFIELD mydate \@"DD/MM/YY" }

(use Alt-F9 to display the field codes so you can edit them. You can usually
reasonably safely delete "\*Mergeformat" if you see it)

I'd then verify that "ambiguous" dates where the day number is 12 or below
are not reversed.

Peter Jamieson

>I have an excel datasource with dates formatted to show e.g. 5th June 2007.
>
[quoted text clipped - 6 lines]
> mail
> merge field format to show the correct date format?

Reply to this Message