 |
 | 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 2007Date format frustration
I am trying to complete a mail merge sourced from excel and keep getting the american date format (MM/DD/YY. despite my efforts I am unable to affect a change. All suggestions greatfully received {mergefield "Date_Joined_Company"/"dd/mm/yy} > I am trying to complete a mail merge sourced from excel and keep getting the > american date format (MM/DD/YY. despite my efforts I am unable to affect a > change. All suggestions greatfully received > {mergefield "Date_Joined_Company"/"dd/mm/yy} I am trying to get UK date (DD/MM/YY) >> I am trying to complete a mail merge sourced from excel and keep >> getting the american date format (MM/DD/YY. despite my efforts I am >> unable to affect a change. All suggestions greatfully received >> {mergefield "Date_Joined_Company"/"dd/mm/yy} > I am trying to get UK date (DD/MM/YY) Your syntax is wrong - try {Mergefield Date_Joined_Company \@ "dd/mm/yy"} See - http://www.gmayor.com/formatting_word_fields.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><< Not sure about merge fields, but on date and time fields generally, the "M" in the picture is case-sensitive, in that upper case gives a month while lower case gives minutes. SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. >>> I am trying to complete a mail merge sourced from excel and keep >>> getting the american date format (MM/DD/YY. despite my efforts I am [quoted text clipped - 6 lines] > > See - http://www.gmayor.com/formatting_word_fields.htm Oops - you are right - a senior moment :( Let's change that for {Mergefield Date_Joined_Company \@ "dd/MM/yy"} Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Not sure about merge fields, but on date and time fields generally, > the "M" in the picture is case-sensitive, in that upper case gives a [quoted text clipped - 18 lines] >> Word MVP web site http://word.mvps.org >> <>>< ><<> ><<> <>>< ><<> <>>< <>><< Well spotted Thanks Graham > >> I am trying to complete a mail merge sourced from excel and keep > >> getting the american date format (MM/DD/YY. despite my efforts I am [quoted text clipped - 6 lines] > > See - http://www.gmayor.com/formatting_word_fields.htm See http://addbalance.com/word/datefields1.htm for information on the different kinds of datefields and how to format them. While this is about the CREATEDATE and DATE fields, the formatting pictures work for mergefields as well if your date data is in standard date format. SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. >I am trying to complete a mail merge sourced from excel and keep getting >the > american date format (MM/DD/YY. despite my efforts I am unable to affect a > change. All suggestions greatfully received > {mergefield "Date_Joined_Company"/"dd/mm/yy} Go to Start: Settings: Control Panel: Regional & Language Options, Then go into the Regional Options tab: click on customize (beside English) click on date tab: In the box for (Short date format):type in mm/dd/yyyy. That should solve your problem. > I am trying to complete a mail merge sourced from excel and keep getting the > american date format (MM/DD/YY. despite my efforts I am unable to affect a > change. All suggestions greatfully received > {mergefield "Date_Joined_Company"/"dd/mm/yy} This helped me and worked fine with same problem > I am trying to complete a mail merge sourced from excel and keep getting the > american date format (MM/DD/YY. despite my efforts I am unable to affect a > change. All suggestions greatfully received > {mergefield "Date_Joined_Company"/"dd/mm/yy} Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but then after the mail merge it appears has 01/17/2006. I tried to format, I change to toogle and format as you told me, I get this filead: {Mergefield Data \@ "dd/mm/yyyy" } and this result: 17/00/2006 Why the months apears as zeros? I even tried to change in Regional Setting the short date to dd/mm/aa but nothing. The best that I could get was making a trick. After all register in Excel, I insert another register and I put some text into the date column. Any ideas? Regards, Marco > This helped me and worked fine with same problem > > > I am trying to complete a mail merge sourced from excel and keep getting the > > american date format (MM/DD/YY. despite my efforts I am unable to affect a > > change. All suggestions greatfully received > > {mergefield "Date_Joined_Company"/"dd/mm/yy} Hi. I already find out my problem. I wasn't using M in upper case. I was using mm. Marco > Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but > then after the mail merge it appears has 01/17/2006. [quoted text clipped - 22 lines] > > > change. All suggestions greatfully received > > > {mergefield "Date_Joined_Company"/"dd/mm/yy} Hi Marco, Lowercase ms are for minutes - uppercase Ms for months. Try: {Mergefield Data \@ "dd/MM/yyyy" } Cheers Signaturemacropod [MVP - Microsoft Word] | Hi. I'm experience this problem. I have in excel this date: 17-01-2006 but | then after the mail merge it appears has 01/17/2006. [quoted text clipped - 22 lines] | > > change. All suggestions greatfully received | > > {mergefield "Date_Joined_Company"/"dd/mm/yy} |
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.