 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2004Format \@ "dd/MM/yyyyy" Return Today date
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 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.  SignaturePlease 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 > I'd merged an Date Field. > It's show dd/MM/yyyy hh:mm:ss format so i work on a field and write [quoted text clipped - 4 lines] > i use word 2000 with access 2000, i had done a standard mailmerge.. > Thank's I'd Tryed but the problem is not go away. i have no idea. Thank's. 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. SignaturePlease 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 > I'd Tryed but the problem is not go away.. > i have no idea.. > Thank's. 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 :-) 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 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 :-) Using Query all it's OK !!! Thank you very very very much 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 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? SignaturePlease 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 > Hi =?Utf-8?B?RGFuaWVsZSBQaW5haQ==?=, > [quoted text clipped - 4 lines] > > Cindy Meister 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.