Unwanted time inserted into merge field

[Sharon VA]

Mail merge is inserting "12:00:00 AM" where a field should be left blank.
There is no data to merge into that field. The data that would be merged if
the field were not blank is a date i.e. 1/30/04

 

[Peter Jamieson]

Try inserting the following nested field:

{ IF "{ MERGEFIELD mydate }" = "12:00:00 AM" "" "{ MERGEFIELD mydate }" }

where mydate is the name of your date field.

The {} should all be inserted using ctrl-F9. The "12:00:00 AM" should be
exactly the same as the result you see if you insert

{ MERGEFIELD mydate }

Peter Jamieson