| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How 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? |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
How do I convert a date/time field in a merge field?
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. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "TEB1824" wrote in message ... 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? |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
How do I convert a date/time field in a merge field?
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. -- 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. |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
How do I convert a date/time field in a merge field?
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. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Graham Mayor" wrote in message ... 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. -- 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. "TEB1824" wrote in message ... 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? |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
How do I convert a date/time field in a merge field?
"Rich/rerat" wrote: 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. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Graham Mayor" wrote in message ... 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. -- 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. "TEB1824" wrote in message ... 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? |
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
How do I convert a date/time field in a merge field?
Thank you and Graham for your help I followed your instructions and it worked.
"Rich/rerat" wrote: 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. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Graham Mayor" wrote in message ... 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. -- 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. "TEB1824" wrote in message ... 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? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UK dating in date-time picture field | Mailmerge | |||
| Date/Time Field | Microsoft Word Help | |||
| Mail merge with Word 2003 and SQL 2005 on a date and time field. | Mailmerge | |||
| Date Time Field that auto updates - Merge Documents | Microsoft Word Help | |||
| how do i delete "time" from date/time merge field in mail merge? | Mailmerge | |||
Hybrid Mode
