Microsoft Access to Microsoft Word mailmerge – dates in wrong format

I was using data from a Microsoft Access query in a Microsoft Word mailmerge document the other day. However on returning dates they were in the American format rather than the UK one, although both Microsoft packages were showing my language as English UK.

I was very keen that the dates went out in UK format.

To change it, right click on the Date itself, then click Edit Field. The Field dialog box will be displayed.

Ensure MergeField is selected in the Field names section and that the relevant date field is selected in the Field name box.

Click Field Codes. In the Advanced Fields section type \@”dd/MM/yyyy” immediately after the field name.

Click OK. Your date will be formatted correctly.

Find out more about our Microsoft Access training in the London area or our Microsoft Access training in Wiltshire, Dorset, Somerset and Hampshire

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Access, Microsoft Access 2013, Microsoft Access 2016, Microsoft Word, Microsoft Word 2013, Microsoft Word 2016 and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s