Hi ?B?R3JhaGFtIEJsdW5kZWxs?=,

It's not a mail merge. I'm using the [{DOCProperty} field] to extract
information from a DBF file (via a series of macros written by the insurance
agency management system vendor to interface their databases with Word). I'm
using Word 2000. I can use these [docProperty] fields in any Word fields, such as
{IF}, {=}, {QUOTE}, etc.

Can you get the macros to drop the D/A and the data numbers in separate documnent
properties? If you can, then you can turn the numbers into a date like this:

{ Quote { DocProperty test \# "00–00–00" } \@ "dd-MMM-yyyy"}

(IMPORTANT: The - between the 00 above is Ctrl+minus on the numeric keypad)

There would be no problem, of course, turning D or A into Delete and Add using an
IF field.


I have a data field that could contain entries such as D112904 or A112904,
meaning "Deleted 11/29/04" or "Added 11/29/04". I can use an IF statement to
test for D* or A* and insert "Deleted" or Added" but how do I format the
date?


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail :-)