Mailmerge and Date Formats 1

[sdmgeek]

I am creating a MailMerge Document from a query on an Access database. As I live in Ireland the date format on the database is Short Date dd/mm/yyyy. When I preview the MailMerged Word document, the order has been reversed to mm/dd/yyyy.

My Regional Settings are set correctly in Control Panel to English(Ireland) and I've tried modifying the field codes to \@ "dd MMMM yyyy" but to no avail.

Any tips would be greatly appreciated.

Thanks.

 

[Remou]

Have you tried formatting the date in the query?

 

[sdmgeek]

How do I do that?

Thanks.

 

[Remou]

Add format to the column that the date in in so that it reads something like:
FormatDate: Format([TheDate],"DD MMMMM YYYY")

 

[sdmgeek]

Thanks, Remou, I tried that but still no joy. I ended up formatting the field as a Long Date in both the MS Access Table and Query, then pasting the results of the query into an Excel Spreadsheet. I used the spreadsheet as the source for the mailmerge and it worked a treat.

Thanks for the help.