Date Field - Switch to Suppress

[Charles]

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

 

[Graham Mayor]

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


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

 

[Charles]

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

Regards

Charles