 |
 | 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 / March 2008How do I convert a date/time field in a merge field?
I created a report in Crystal Reports. I exported the report into excel with all the appropriate fields. I created the mail merge file in Microsoft word. I basically edited all the text fields to my satisfaction. However I have a date/time field that refuses to be converted to the desired format, dddd, MMMM dd, yyyy, which is Tuesday, March 18, 2008. It is seems to be stuck on the M/d/yyyy h:mm am/pm format which is 3/18/2008 12:00 AM. It doesn't change no matter how I change the format in either excel or Crystal Reports. How can this be corrected? TEB1824, Try using the following switch after the date mergefield: \@ "DDDD MMMM dd, yyyy" Take note for the day of the week I used four (4) capital "D"'s.  SignatureAdd MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> I created a report in Crystal Reports. I exported the report into excel with all the appropriate fields. I created the mail merge file in Microsoft word. I basically edited all the text fields to my satisfaction. However I have a date/time field that refuses to be converted to the desired format, dddd, MMMM dd, yyyy, which is Tuesday, March 18, 2008. It is seems to be stuck on the M/d/yyyy h:mm am/pm format which is 3/18/2008 12:00 AM. It doesn't change no matter how I change the format in either excel or Crystal Reports. How can this be corrected? The DDDD does not have to be upper case - only the MMMM. If you want the *result* upper case you need an additional switch \@ "dddd MMMM d, yyyy" \*upper conversely a \*lower switch would make the result all lower case. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > TEB1824, > Try using the following switch after the date mergefield: > > \@ "DDDD MMMM dd, yyyy" > > Take note for the day of the week I used four (4) capital "D"'s. Graham Mayor, My apologies, after reading the OP again, the author might have just formatted the excel worksheet to the format they wanted. But had not used the switch in the Word document to make the mergefield date as they wanted it to be displayed as. Since they mention trying "dddd" for the day of the week, and it did not work. SignatureAdd MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> The DDDD does not have to be upper case - only the MMMM. If you want the *result* upper case you need an additional switch \@ "dddd MMMM d, yyyy" \*upper conversely a \*lower switch would make the result all lower case. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Rich/rerat wrote: > TEB1824, > Try using the following switch after the date mergefield: > > \@ "DDDD MMMM dd, yyyy" > > Take note for the day of the week I used four (4) capital "D"'s. I created a report in Crystal Reports. I exported the report into excel with all the appropriate fields. I created the mail merge file in Microsoft word. I basically edited all the text fields to my satisfaction. However I have a date/time field that refuses to be converted to the desired format, dddd, MMMM dd, yyyy, which is Tuesday, March 18, 2008. It is seems to be stuck on the M/d/yyyy h:mm am/pm format which is 3/18/2008 12:00 AM. It doesn't change no matter how I change the format in either excel or Crystal Reports. How can this be corrected? > Graham Mayor, > My apologies, after reading the OP again, the author might have just [quoted text clipped - 26 lines] > change no matter how I change the format in either excel or Crystal Reports. > How can this be corrected? Thank you and Graham for your help I followed your instructions and it worked. > Graham Mayor, > My apologies, after reading the OP again, the author might have just [quoted text clipped - 26 lines] > change no matter how I change the format in either excel or Crystal Reports. > How can this be corrected? |
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.