how do I set up UK dates for mail merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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]
 
Or go to Word, and apply a date format to the merge field.

(david)
 
Back
Top