Word Mailmerge from Access gives wrongly-formatted dates

[Nick Howes]

Hello,
I would post this in m.p.word.mailmergefields but it seems empty.

I've got a database that I made in Access 97, that had some dates in. When I
merged these into a word document, they come out dd/mm/yyyy, which is how I
want it (I live in the UK). I now use Office XP, and the dates merge as
mm/dd/yyyy (the US way). Access still displays the UK type dates, and if I
insert the current date into Word, it also makes a UK date, so I can't
figure out what setting is making it insert a US-style date?

Any help or suggestions would be appreciated, thanks

 

[John Vinson]

Hello,
I would post this in m.p.word.mailmergefields but it seems empty.

I've got a database that I made in Access 97, that had some dates in. When I
merged these into a word document, they come out dd/mm/yyyy, which is how I
want it (I live in the UK). I now use Office XP, and the dates merge as
mm/dd/yyyy (the US way). Access still displays the UK type dates, and if I
insert the current date into Word, it also makes a UK date, so I can't
figure out what setting is making it insert a US-style date?

Any help or suggestions would be appreciated, thanks

Access stores dates as Double Float numbers, not as text. You'll want
to create a Query using the Format() *function* to cast the numbers
into a text string:

ExpDate: Format([datefield], "dd/mm/yyyy")

and mailmerge this field.

 

[Nick Howes]

Access stores dates as Double Float numbers, not as text. You'll want
to create a Query using the Format() *function* to cast the numbers
into a text string:

ExpDate: Format([datefield], "dd/mm/yyyy")

and mailmerge this field.

Thanks John, I'll give that a go. Any ideas why it used to work under Access
97 when I just put the date into the query?

 

[John Vinson]

Access stores dates as Double Float numbers, not as text. You'll want
to create a Query using the Format() *function* to cast the numbers
into a text string:

ExpDate: Format([datefield], "dd/mm/yyyy")

and mailmerge this field.

Thanks John, I'll give that a go. Any ideas why it used to work under Access
97 when I just put the date into the query?

Not a clue! Maybe 200x treats the user's Regional settings differently
than 97 did.