Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I calculate a date from a merge field?
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I omit an empty date merge field? | Microsoft Word Help | |||
Date Field in Merge Document | Mailmerge | |||
Date mail merge field shows as serial | Mailmerge | |||
using date field in merge | Mailmerge | |||
How do I filter a Dbase date field in a word mail merge documnet? | Mailmerge |