how do I set up UK dates for mail merge

[Guest]

I have set up the UK date format (dd/mm/yr) in Control Panel, Access and Word
but when I mail-merge a document from a database with a UK date Access
translates it into a US date (mm/dd/yr) in th resulting document.

 

[John Vinson]

I have set up the UK date format (dd/mm/yr) in Control Panel, Access and Word
but when I mail-merge a document from a database with a UK date Access
translates it into a US date (mm/dd/yr) in th resulting document.

Mail merge (as you have seen) ignores any Format settings for fields.
The date value is actually stored as a number, a count of days since
an arbitrary start point.

To mailmerge a UK date, use a Query with an explicit call to the
Format() function: in a vacant field cell type

ExpDate: Format([datefield], "dd/mm/yy")

This will create a text string formatted British style, and that text
string will be exported.

John W. Vinson[MVP]

 

[david epsom dot com dot au]

Or go to Word, and apply a date format to the merge field.

(david)