DateTime Field From Access show Time Format

[Daniele Pinai]

I' d wrote an word document.
Whith mail merge with Access2000 File i had insert a DateTime field.
when i show date in the document i see " 31/12/2003 0.00.00 "
so i had formatted the filed with \@ "dd/MM/yyy" tag
and after that i read the correct format by the date i see is always
the date of the day "20/01/2004" ... in the Access file i have 31/12/2003

How it's possible ???
What i must to do ?
Thank's a lots for your help...

sorry form my English
Daniele Pinai
from Italy

 

[Peter Jamieson]

Can you tell us exactly what text is in your field?

It sounds to me as if you are actually using a DATE field such as { DATE \@
"dd/MM/yyyy" } rather than the { MERGEFIELD mydatefield "dd/MM/yyyy" } that
you probably want.

 

[Graham Mayor]

Can you tell us exactly what text is in your field?

It sounds to me as if you are actually using a DATE field such as {
DATE \@ "dd/MM/yyyy" } rather than the { MERGEFIELD mydatefield
"dd/MM/yyyy" } that you probably want.

Or even { MERGEFIELD mydatefield \@ "dd/MM/yyyy" }

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Daniele Pinai]

i don't use DATE in my mailmerge bu
{ MERGEFIELD Data_Nascita \@ "dd/MM/yyyy"

Data_Nascita is the name that i have in my Access Tabl

but word show to me the date of the day..
Why ? do u know
Thank's a lot

Daniele Pina
From Ital

 

[Peter Jamieson]

Well spotted Graham!

 

[Daniele Pinai]

I don't use DATE in my mailmerge bu
{ MERGEFIELD Data_Nascita \@ "dd/MM/yyyy"

Data_Nascita is the name of the filed that i have in my Access Tabl

but word show to me the date of the day..
Why ? do u know
Thank's a lot

Daniele Pina
From Ital

 

[Peter Jamieson]

No I can't see why this would generate today's date unless the field had
today's date (or is calculated in an Access table to be today's date).

Does { MERGEFIELD Data_Nascita } give the right date (but in the wrong
format) ?

Are you using Word 2000?

Are you connecting using DDE (the default in Word 2000) or ODBC?

 

[Daniele Pinai]

Yes ... { MERGEFIELD Data_Nascita } give the right date but in the wron
format !!

Yes i Know it's crazy..but it's true..
I have Word2000 and Access2000 and i connet them using the tools/mailmerge default mode.

If u can...Help me !!
Than's

Daniele Pina

 

[Graham Mayor]

What happens if you add the date mask \@ "dd/MM/yyyy" and press F9?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Daniele Pinai]

What happens if you add the date mask \@ "dd/MM/yyyy" and press F9?

I'd wrote { MERGEFIELD Data_Nascita \@ "dd/MM/yyyy" }
after that i'd press F9 and it show me the default setting <<Data_Nascita>>

If i try to show data i seen The date of this day :-(((

In the Database Data_nascita Is 12/04/1976 :-((((
Thank's

 

[Graham Mayor]

Are you completing the merge or viewing the merge document? Merge to a new
document and what happens?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Budget Print Center]

"but word show to me the date of the day..."

Perhaps better translatoin would be today's date... which i believe are not
the dates listed in the field.... just a guess, danielle . my italian
english is not so good.

 

[Daniele Pinai]

If i merge in a new document all go fine
On my machine.... even go fine..
But if my customer send to me your wrong file also on my machine
i see the date of the day..