ddMMMMyyyy

C

Christine

We have a Database which we have recently converted from
Access 97 to Access XP. Since then when merging it with
Word the dates have been giving us a problem.

In Access the dates all display correctly as Medium Date
(08-April-2004) but in the Word document after merging the
date can appear with what should be the day displaying as
the month and the month displaying as the day which makes
a total nonsense of the dates inserted in Access. I have
checked all the settings ie Regional & Language Options,
but on this one computer the date will insist on
displaying back to front.

On my computer it displays incorrectly unless I add
\@"ddMMMMyyyy into the Word merge document when it
displays correctly. Adding this to the other computer
makes no difference!

Any help would be much appreciated. Ta.

Christine Ward
 
A

Allen Browne

Create a query, and explicitly format the dates there.
Use the query as the merge source in Word.

Example:
MyDate4Word: Format([MyDate], "Medium Date")


BTW, since you are working in a country that does not use the US date
format, check out:
International Date Formats in Access
at:
http://members.iinet.net.au/~allenbrowne/ser-36.html
for hints on handling the 3 situations where Access misunderstands out
dates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top