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?