Empty > 12:00:00 AM?

  • Thread starter Thread starter =?iso-8859-1?Q?JethroUK=A9?=
  • Start date Start date
?

=?iso-8859-1?Q?JethroUK=A9?=

Empty date field in XL when mailmerged reads:

12:00:00 AM

The merge field contains {MERGEFIELD "MDP"} no additional formatting

Any Ideas? I was wondering whether i can use an 'If' command with this, or
maybe some formatting option?
 
You can use a conditional field to trap it

{IF {Mergefield MDP} <> "12:00:00 AM" "{Mergefield MDP}" }

should do the trick.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top