Wrong Date format when combining Access with word document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I live in Spain and here the date format is a bit different than in the
United States.
I've just upgraded to Office 2003 and now, when I combine my word documents
with my access database, all of the dates come out in a US format.

If you look at the database, the dates are in the European format. It seems
that the change is in date format is occurring somewhere on the way between
access and the word document.

Can anybody help me fix this?
 
Actually, dates are stored as 8 byte floating point numbers (the integer
portion represents the date as the number of days relative to 30 Dec, 1899,
and the decimal portion represents the time as a fraction of a day).

Try explicitly formatting the dates (using the Format function) when you're
extracting them.
 
Is should be possible to format the fields in Word.

You can also do it in Access if you export a query instead of the table.
Create a query to format the dates the way you want them, e.g.:
InvDate: Format([InvoiceDate], "yyyy\-mm\-dd")
Then use the query as the merge source.

(Internally, Access stores the date as a number, so it actually has no
format until it is displayed.)
 
Back
Top