 |
 | 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 / January 2004DateTime Field From Access show Time Format
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 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. -- Peter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ > I' d wrote an word document. > Whith mail merge with Access2000 File i had insert a DateTime field. [quoted text clipped - 10 lines] > Daniele Pinai > from Italy > 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" } :)  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP E-mail gmayor@mvps.org Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><< Well spotted Graham! -- Peter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ > > Can you tell us exactly what text is in your field? > > [quoted text clipped - 11 lines] > Word MVP web site www.mvps.org/word > <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><< 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 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? -- Peter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ > I don't use DATE in my mailmerge but > { MERGEFIELD Data_Nascita \@ "dd/MM/yyyy" } [quoted text clipped - 7 lines] > Daniele Pinai > From Italy 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 What happens if you add the date mask \@ "dd/MM/yyyy" and press F9? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP E-mail gmayor@mvps.org Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Yes ... { MERGEFIELD Data_Nascita } give the right date but in the > wrong [quoted text clipped - 8 lines] > > 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 Are you completing the merge or viewing the merge document? Merge to a new document and what happens? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP E-mail gmayor@mvps.org Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > What happens if you add the date mask \@ "dd/MM/yyyy" and press F9? > [quoted text clipped - 6 lines] > In the Database Data_nascita Is 12/04/1976 :-(((( > Thank's 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.. 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 "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. Signature"Display tolerance & kindness to those with less knowledge than you because there is ALWAYS someone with more" > i don't use DATE in my mailmerge but > { MERGEFIELD Data_Nascita \@ "dd/MM/yyyy" } [quoted text clipped - 7 lines] > Daniele Pinai > From Italy |
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.