How do I convert a date/time field in a merge field?

[TEB1824]

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?

 

[Rich/rerat]

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>>


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]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Rich/rerat]

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>>


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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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?

 

[TEB1824]

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>>


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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>





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]

Thank you and Graham for your help I followed your instructions and it worked.