I have a merge document set up that uses a data source from a database. I
need to compute a date field to give me the date 1 day before the date from
the data. How do I do that?

With some difficulty - but see
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902

--

Graham Mayor - Word MVP

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


Bianca Sergueeva wrote:
I have a merge document set up that uses a data source from a
database. I need to compute a date field to give me the date 1 day
before the date from the data. How do I do that?

Thank for your response, but I still can't find the answer to my question -
can you point me to the right paragraph or just type in the calculation for
me? Many, many thanks indeed.

Bianca

"Graham Mayor" wrote:

With some difficulty - but see
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902

--

Graham Mayor - Word MVP

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


Bianca Sergueeva wrote:
I have a merge document set up that uses a data source from a
database. I need to compute a date field to give me the date 1 day
before the date from the data. How do I do that?

This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different
kinds of ways to make a date calculation work. It includes links to pages
with fields and an explanation of different macros that can be used instead
of fields. (You would be starting from your mergefield rather than from a
regular date field.)

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Bianca Sergueeva" wrote in
message ...
I have a merge document set up that uses a data source from a database. I
need to compute a date field to give me the date 1 day before the date
from
the data. How do I do that?

I must be really thick, but I still can't work out how to do the calculation.
I've managed to do it for 1 day before TODAY, but not 1 day before the date
from the date in the merge.

Please help!

"Charles Kenyon" wrote:

This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different
kinds of ways to make a date calculation work. It includes links to pages
with fields and an explanation of different macros that can be used instead
of fields. (You would be starting from your mergefield rather than from a
regular date field.)

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Bianca Sergueeva" wrote in
message ...
I have a merge document set up that uses a data source from a database. I
need to compute a date field to give me the date 1 day before the date
from
the data. How do I do that?

I managed to get there in the end!!! Your document is really good - just it
take a while to work out what the code represents (eg the one for today's
date).

Thanks a million!!!

Bianca

"Charles Kenyon" wrote:

This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different
kinds of ways to make a date calculation work. It includes links to pages
with fields and an explanation of different macros that can be used instead
of fields. (You would be starting from your mergefield rather than from a
regular date field.)

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Bianca Sergueeva" wrote in
message ...
I have a merge document set up that uses a data source from a database. I
need to compute a date field to give me the date 1 day before the date
from
the data. How do I do that?