View Single Post
  #1   Report Post  
Curious of Barnet
 
Posts: n/a
Default Word Mailmerge reading UK dates in Access as US dates

I have an Access Database which contains a date field, formatted as a UK
date, i.e. dd/mm/yy hh:mm. When I use the Word mailmerge facility to pull in
information about an overdue book loan the date is read by word as being in
US format, i.e. mm/dd/yy hh:mm, so that 5th November 2003 is printed in the
mailmerge as 11th May 2003. How do I make Mailmerge read the date correctly?