I recently had a problem with all dates coming through to my mail merge template being in the American date format - i.e. MM/DD/YYYY.
With some help from the experts ( http://www.experts-exchange.com/Applications/Q_22050089.html
), I thought I had the problem nailed.
I was wrong.
Now, when I do a mail merge, if the date that comes through could potentially be valid in both formats - for example 06/11/2006 is a valid UK date (6th November 2006) and a valid US date (11th June 2006) - the mail merge chooses the american option every time. To be pedantic, passing in 06/11/2006 to the mail merge results in 11/06/2006 appearing in the results.
If the date is only valid in the uk format, e.g. 23/6/2006, then it will show correctly as 23/6/2006.
This is extremely irritating, as you can imagine, how can I tell Word that the date format is ALWAYS the UK format! As you can see from the above question, I have already tried all of the obvious Office and Windows date settings.