I am attempting to run a mail merge between Access and Word 2003.

I am using the switch {MERGEFIELD FIELDNAME \@"dd/MM/YYYY"\*MERGEFORMAT} to
change from the full american date format (ie 09/25/2003 12:00 am) to a
simplified australian date (25/09/2003) for the 25th of September 2003.

This works fine when the number of days is greater than 12. However any date
where the number of days is 12 or below is not switching the date ie 3rd of
September 2003 is showing as 09/03/2003 when it should read 03/09/2003.

Does anyone know what i have got wrong?
Cheers Alan

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/cindy...r/MergFram.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Alan" wrote in message
...
I am attempting to run a mail merge between Access and Word 2003.

I am using the switch {MERGEFIELD FIELDNAME \@"dd/MM/YYYY"\*MERGEFORMAT}
to
change from the full american date format (ie 09/25/2003 12:00 am) to a
simplified australian date (25/09/2003) for the 25th of September 2003.

This works fine when the number of days is greater than 12. However any
date
where the number of days is 12 or below is not switching the date ie 3rd
of
September 2003 is showing as 09/03/2003 when it should read 03/09/2003.

Does anyone know what i have got wrong?
Cheers Alan