Mail merge date field UK/US format problem

[starsky51]

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.

 

[Doug Robbins - Word MVP]

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


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