You would have to trap what the field actually produces with a conditional
field construction eg
{IF {Mergefield Fieldname} "12:00:00 AM" "{Mergefield Fieldname \@
"dd/MM/yyyy"}"}
The bracket pairs {} are each entered with CTRL+F9.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Charles wrote:
Hi
I'm creating a mailmerge with an Excel spreadsheet in Word 2002.
A number of the fields are dates and sometimes the date is missing in
the spreadsheet.
In Word this blank date is showing as 12:00:00 AM. I have added the
Switch \@ "dd/mm/yyyy" to stop this displaying, but it didn't work.
How do I suppress this?
Thanks