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