Reply
 
Thread Tools Display Modes
  #1   Report Post  
Duncan McDonald
 
Posts: n/a
Default Working with Mergefields

Hi Graham

Thanks for your help.

The site I was directed to is good but there appears to be a discrepancy
with the calculation of adding 'n' months. If you add n=6 to 1/12/04 the
answer comes out as 30/6/05.

I agree excel would be better to use but I would prefer to avoid it if
possible


"Graham Mayor" wrote:

If this is an excel data file, it will be simpler to add another column to
the file and use it to calculate the date required.
Otherwise you are going to have to investigate the complexity of calculated
fields - 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




Duncan wrote:
I have a document that inputs data using mergefields. One
peice of data is a date called 'StartDate' another is
'Duration'.
Duration is in number of months and StartDate is a date.
I need to:
a) add the duration to the date + one day and output
through the document.
b) If the date is entered 'd/mm/yyyy' I want the output
date to be formatted as ie. 21st January 2004 both for the
StartDate value and the calculated date value

Any help would be appreciated




  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

'Macropod' frequently monitors these newsgroups, maybe he will comment.

--

Graham Mayor - Word MVP

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




Duncan McDonald wrote:
Hi Graham

Thanks for your help.

The site I was directed to is good but there appears to be a
discrepancy with the calculation of adding 'n' months. If you add n=6
to 1/12/04 the answer comes out as 30/6/05.

I agree excel would be better to use but I would prefer to avoid it if
possible


"Graham Mayor" wrote:

If this is an excel data file, it will be simpler to add another
column to the file and use it to calculate the date required.
Otherwise you are going to have to investigate the complexity of
calculated fields - 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




Duncan wrote:
I have a document that inputs data using mergefields. One
peice of data is a date called 'StartDate' another is
'Duration'.
Duration is in number of months and StartDate is a date.
I need to:
a) add the duration to the date + one day and output
through the document.
b) If the date is entered 'd/mm/yyyy' I want the output
date to be formatted as ie. 21st January 2004 both for the
StartDate value and the calculated date value

Any help would be appreciated



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
my copy/cut paste function is not working. what is wrong Mrs Roberts Microsoft Word Help 0 January 7th 05 11:49 PM
Working with text and graphics in a large document Marcia Mayne Microsoft Word Help 1 December 31st 04 04:34 AM
Converting hyperlinks in .doc to working links in .htm... Petter Hære Microsoft Word Help 3 December 16th 04 05:05 AM
Working several docs at the same time with Word 2000 Frode Hjønnevåg Microsoft Word Help 2 December 2nd 04 08:25 PM
Word 2003 autocomplete not working Cindy M -WordMVP- Microsoft Word Help 2 December 2nd 04 05:35 PM


All times are GMT +1. The time now is 05:19 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"