Unwanted time inserted into merge field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharon VA - 22 Mar 2005 19:57 GMT

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

Reply to this Message

Peter Jamieson - 22 Mar 2005 23:22 GMT

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

> 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

Reply to this Message