It is a date field from an MSSQL database that is passed as a dBase expression,
that when I add 30 is shows the date 30 days in advance.
excerpt snipit...
{if"{ddeauto goldmine data (contact2->uappreqfu1)}">' ' {ddeauto goldmine data
contact2->uappreqfu1+15}\@"MMM d, yyyy"}
You will notice that I have two similar fields, only one prints the date+30 or
date+15 depending on the boolean of a date in the first followup field.
I've gotten around my original problem by using my last printed dates and adding
the appropriate remaining days.
The only thing is; say a letter was printed 7 days ago, but for some reason it
was wrong and was not sent out.
I don't want my users having to find that record in the database, the QA person
just does their task to set it to reprint and later that day it does.
But it would add 30 or 15 days to the 7 days old last followup print date.
What would be best is if I could add the correct days to the print date in the
doc depending on if the last print date had a value, but not evaluate the date,
just say yes or no and add 30 or the remaiing 15 days.
TIA
JeffP.....
> If you are still monitoring this thread, I would be interested to know
> exactly what the text in your ddeauto field is, and what kind of thing
[quoted text clipped - 61 lines]
> >> >
> >> > JeffP.....
Peter Jamieson - 10 Jun 2005 22:49 GMT
Hi JeffP,
Thanks for the clarification re. DDEAUTO. There are a couple of other
possible approaches to this but since it seems you have found one that works
I wouln't be inclined to touch it.
Re. the business of reprinting stuff, I suspect I have not fully understood
but can only suggest that
a. once /Word/ thinks you have printed, and the document is saved, the
document is going to contain the date Word thought you had printed it on. It
doesn't know that someone threw the thing in the bin.
b. so I suspect what really needs to change is the procedure - i.e.,
someone has to start slightly further back in the process and do a
"re-merge", rather than just doing a "reprint".
Peter Jamieson
> It is a date field from an MSSQL database that is passed as a dBase
> expression,
[quoted text clipped - 103 lines]
>> >> >
>> >> > JeffP.....