backwards date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 20 Dec 2004 05:04 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 20 Dec 2004 08:03 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

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

> I am attempting to run a mail merge between Access and Word 2003.
>
[quoted text clipped - 8 lines]
> Does anyone know what i have got wrong?
> Cheers Alan

Reply to this Message