 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2005How 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? With some difficulty - but see www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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 > With some difficulty - but see > www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 > > > 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.) SignatureCharles 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. >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! > 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 [quoted text clipped - 7 lines] > > 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 > 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 [quoted text clipped - 7 lines] > > from > > the data. How do I do that? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.