Mail merge date field UK/US format problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

starsky51@gmail.com - 05 Jan 2006 12:20 GMT

I have a mail merge word document using an xls as data source. One of
the fields I am extracting is Appointment_Date which is in UK format
("dd/mm/yyyy").
I add the field to the document using it's default layout with field
code: {MERGEFIELD "Appointment_Date"}. This gives me the date in the UK
format: '06/01/2006'. But, when I add a format tag to the field code:
{MERGEFIELD "Appointment_Date" \@ "dddd d MMMM"}, the date seems to be
retrieved in US format and gives 'Thursday 1 June'.

Has anyone had this problem in the past? Any ideas how to workaround
this quirk?

Dave.

Reply to this Message

Doug Robbins - Word MVP - 05 Jan 2006 18:47 GMT

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

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

>I have a mail merge word document using an xls as data source. One of
> the fields I am extracting is Appointment_Date which is in UK format
[quoted text clipped - 9 lines]
>
> Dave.

Reply to this Message