Date Field - Switch to Suppress

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

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

Thank very much Graham, as always, I can rely on great assistance here.

Regards

Charles

"Graham Mayor" wrote:

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