Time Issue

[riri]

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

 

[Peter Jamieson]

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