Suzanne,
Try using the following switch
\@ "dd'-'MMM'-'yyyy"
Make sure you use single quotes (') around each dash (-).
--
Add MS to your News Reader:
news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate
"Suzanne" wrote in message
...
I have an Excel spreadsheet with three columns of dates. All three columns
are formatted in Excel exactly the same way (10-Feb-2008)
The first and third column are showing up in the Word merge document AND in
the Mail Merge Recipients window as a serial date.
The second column is showing up in the Recipients window as a date, but not
in the right format (2/10/2008).
I set a switch code in the date fields to force the date format I need, but
(obviously) am having no luck. Help????
This one is showing up as "39488"
{MERGEFIELD "PROCESS_START_DATE" \@ "dd MMM yyyy" }
This one is showing up as "2/10/2008"
{MERGEFIELD "ACTUAL_SURVEY_DATE" \@ "dd MMM yyyy" }