Time Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

riri - 17 Jul 2007 11:28 GMT

Hello again,

I checked this option Confirm Conversion at open in word and then I
try to open my excel sheet
to get the date for the mergge but I still get the 12:00:00 AM in
some
of the records..If I have only that record in the excel sheet it is
working fine without giving me any 12:00:00AM. Therefore the fields
that appear with 12:00:00 AM are not empty. Is there any other
solution for this issue?

Thanks in advance

Reply to this Message

Peter Jamieson - 17 Jul 2007 17:16 GMT

Are you definitely selecting the DDE option when you are prompted for the
different connection methods?

If so, you may need to use an IF field such as

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

where all the {} are the special field code braces you can insert using
ctrl-F9.

The match will need to be exact, i.e. if your MERGEFIELD field returns
12:00:00AM with no spaces, that's what you will need to compare with.
Unfortunately if you have /real/ entries that actually need to say 12:00:00
AM this approach obviously won't work.

(I'm not sure whethert he following link is relevant in this case

http://tips.pjmsn.me.uk/t0003.htm

)

Peter Jamieson

> Hello again,
>
[quoted text clipped - 8 lines]
>
> Thanks in advance

Reply to this Message

Rate this thread: