Dear All,
I've got an excel spreadsheet that holds people's names
and addresses etc.. including 4 date fields which are
used in the mail merge fields. These dates display
correctly in the excel spreadsheet, all the formatting on
the cells is the same (dd MMMM yy) and the date data is
correct (38048). Now, a mail merge word document is used
to extract data from the excel spreadsheet to the merge
fields. Originally the dates were displaying incorrectly.
for instance the 15th of march would display as
3/15/2004, but thanks to the help of this newsgroup, I've
put in the code to make that 15 March 2004 { MERGEFIELD
testdate \@ "d MMMM yyyy" \* MERGEFORMAT }. BUT, the
quirk that I have noticed is that I am currently getting
the second of march, displaying as 3 February 2004. This
is quite a pain for us, and I've checked the regional
settings, and that's all correct (English, Australia,
etc). I've tested this and it works for all the dates
where the day value is 13th or over, they display
correctly, but if the day is less than 12, they translate
the day as the month and vice versa. I'm not sure what to
do, and I hope that you learned people would be able to
help me. I have checked the data source, and the
formatting, but I'm not sure what else to check. Is there
an update or service pack that I could run? All versions
of Office are XP (2002). Any help would be of great use.
Thanks in advance.
Sam