How to change date format when using Word Mailmerge

  • Thread starter Thread starter GillJ
  • Start date Start date
G

GillJ

I have been trying to set up a mailmerge using data contained in an Access
database. One of the fields is DOB. I have formatted this field in the
database dd/mm/yyyy. However, when trying to merge the data, this field
appears in Word as mm/dd/yyyy. I've tried without luck to change the format.
Does anybody know how to achieve this?
 
I have been trying to set up a mailmerge using data contained in an Access
database. One of the fields is DOB. I have formatted this field in the
database dd/mm/yyyy. However, when trying to merge the data, this field
appears in Word as mm/dd/yyyy. I've tried without luck to change the format.
Does anybody know how to achieve this?
Click to expand...

Base the merge on a Query with a calculated field:

ShowDOB: Format([dob], "dd/mm/yyyy")

This will explicitly cast it as a string, and Word won't see it as a date/time
and therefore apply its own formatting.
 
You could change your System settings but that's probably not a good
thing to do. Date fields in all applications would be affected.

The solution may lie in Word. It's been a long time since I meddled
with anything but plain vanilla merges but it seems that I used to be
able to perform operation on field data in Word. It should be
possible to use Format() to display the date as you wish.

HTH
 
Back
Top