Empty Date External field returns current date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Whitehead - 06 Jul 2007 10:40 GMT

Using Word 2002, Excel 2002:

Excel is the external data source
Where a date field is blank, the merge field returns the current date. I've
tried to eliminate with
{IF {MERGEFIELD thatdate}="" "" "Date reported: {MERGEFIELD thatdate \@
etc}"}, but the result is the same.

Thanks for listening..!

Roger
Shaftesbury (UK)

Reply to this Message

Graham Mayor - 06 Jul 2007 11:02 GMT

If {Mergefield thatdate} produces the current date when empty, then basing
the condition on a nul result from an allegedly empty record isn't going to
help. You have to work with what you actually get not what you think it
should be. See is the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm helps.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Using Word 2002, Excel 2002:
>
[quoted text clipped - 8 lines]
> Roger
> Shaftesbury (UK)

Reply to this Message

Roger Whitehead - 06 Jul 2007 16:41 GMT

Thanks Graham

I've selected an alternative connection method (can't remember which one
now, but it works).

R

> If {Mergefield thatdate} produces the current date when empty, then basing
> the condition on a nul result from an allegedly empty record isn't going
[quoted text clipped - 14 lines]
>> Roger
>> Shaftesbury (UK)

Reply to this Message

Rate this thread: