View Single Post
  #23  
Old July 2nd, 2008, 12:25 AM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Calculating Dates

Hi Bob,

The date calculation example under the heading 'Date and Time Calculations in a Table' is already interactive, in that it solicits
both the start date (your ntp date) and the number of days to offset.

For your purposes, you apparently need the number of days to offset to be hard-coded, and you need two calculated results. To do
that, what I'd suggest doing is:
.. use the first field from example under the heading 'Date and Time Calculations in a Table' or, if you're setting your document up
as a form, use a date-formatted formfield, give it a bookmark name of 'StartDate' and set its properties to 'calculate on exit';
.. use the second and third fields from the example under the heading 'Calculate a Date Sequence' and:
. modify the second field by replacing all instances of 'DATE' with 'StartDate' and changing the 'SET Delay' field's value from
'1' to '5'; and
. modify the third copy by copying the 'SET Delay' field from the second field and changing it's value to '7'.

Cheers


"Bob W" wrote in message ...
Macropod has the calculations perfect, but I need a way of making the setup
of one of his amazing date field calculations, 'user-interactive'. Here's
what I'm trying to do:

A word .doc has a table that shows a proposed event schedule in this format:
Event 1 (notification to proceed [ntp])
Event 2 (ntp+5 days)
Event 3 (ntp+12 days)
etc.

The goal is to let the user type in an initial NTP date in the first row,
and type in various numbers of days in the remaining rows, and then by
refreshing all the fields, the actual calendar dates for all the subsequent
events are automagically calculated and appear in the table.

example of desired results:
Event 1 (notification to proceed [ntp]): January 1, 2009 typed by user)
Event 2 (ntp+5 days): January 6, 2009 (automatically calculated)
Event 3 (ntp+12 days) January 13, 2009 (automatically calculated)

Macropod's calcuation for this, (found in his downloadable DateCalc
document) is entitled, "calculate a day, month and year, using n days delay".
It requires key values in his field calculation formula to be manually
modified by the 'programmer' - how do we make them user-interactive?

"Doug Robbins - Word MVP" wrote:
if you are a field masochist/afficionado like fellow MVP Macropod, you
can do it as shown at:

http://www.wopr.com/cgi-bin/w3t/show...?Number=249902