Format \@ "dd/MM/yyyyy" Return Today date

[Daniele Pinai]

I'd merged an Date Field.
It's show dd/MM/yyyy hh:mm:ss format so i work on a field and write
{MAILMERGE FieldName \@ "dd/MM/yyyy" }
Now the format is right but the date in the filed showed is EVER the date of the day
How is possiblem
i use word 2000 with access 2000, i had done a standard mailmerge..
Thank's

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Daniele,

I don't know why that is happening. As a work around, try using a query in
Access with Format(FieldName, "dd/MM/yyyy") as the data source.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Daniele Pinai]

I'd Tryed but the problem is not go away.
i have no idea.
Thank's.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Daniele,

Are you saying that it still returns today's date?

If the database is not too big, compact it in Access and email it to me and
I will have a look at it.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RGFuaWVsZSBQaW5haQ==?=,

I'd merged an Date Field.
It's show dd/MM/yyyy hh:mm:ss format so i work on a field and write
{MAILMERGE FieldName \@ "dd/MM/yyyy" }
Now the format is right but the date in the filed showed is EVER the date of the day

Please tell us *exactly* what you have, and what you need. There is no such field name
as "Mailmerge"... And which version of Word are we dealing with?

(You may also want to try explaining in French, if that's your native language)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail

 

[Daniele Pinai]

I use Word 2000 (9.0.2812) and Access 2000 (9.0.2812)
My MDB contains a table _Dati_Soci_Per_Estrazioni
In this table i have a field named Data_Nascita
Data_Nascita="30/03/1976"
I had merged this table in a word document.
and the format in the document was "30/03/1976 0.00.00"
so i had modified the filed property and i had wrote { MAILMERGE Data_Nascita \@ "dd/MM/yyyy"}
after that when i see the merged document i see "26/01/2004".... the today day...every day..change
This is the problem... Thank's a lots..
PS : I'm ITALIAN man ...not french lol ^_^
Daniele Pinai

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RGFuaWVsZSBQaW5haQ==?=,

PS : I'm ITALIAN man ...not french lol ^_^

<LOL> Indeed! Sorry about that. I should have caught it was
but the one "l" at the end of the name! Am I forgiven ?

Thank you for the additional information. I reiterate that
there is no such thing as a Word field "MAILMERGE". If you
are really using that, it could explain why you're seeing
the current date - Word doesn't know what to do with the
field, so make it's best guess, based on the date
formatting switch, and gives you the current date.

Does it work any better if the field looks like this:

{ MERGEFIELD Data_Nascita \@ "dd/MM/yyyy" }

Further to what you're seeing: Are you using an ODBC
connection to the Access database? (Just checking, to make
sure we have all the information.)

Better might be to use a QUERY as the data source. In the
query, you can create an EXPRESSION that will format the
date exactly the way you want to have it come across in
Word. This will make it easier and faster for the user, as
they won't have to make changes to the field codes in Word
every time they set up a merge to this data.

In the first empty column of the Query grid, type something
like:
DataNascita: FORMAT([Data_Nascita], "dd/mm/yyyy")

You'll get a field in the linked data source named
DataNascita that would be used instead of Data_Nascita.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Daniele Pinai]

Using Query all it's OK !!!
Thank you very very very much

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RGFuaWVsZSBQaW5haQ==?=,

Using Query all it's OK !!!
Thank you very very very much

You're most welcome Glad you're now up and running.

Cindy Meister

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Cindy,

What is puzzling me about this one is that I suggested using a Query in
Access on 24 January and Daniel replied on 25 January that he had tried it
and the problem did not go away. Then 4 days later you suggested the same
thing and this time he said it worked?

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi Doug,

What is puzzling me about this one is that I suggested using a Query in
Access on 24 January and Daniel replied on 25 January that he had tried it
and the problem did not go away. Then 4 days later you suggested the same
thing and this time he said it worked?

I can only guess that perhaps he didn't understand that first time
exactly what you were suggesting? I did elaborate a bit more...

Cindy Meister