Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    405
    Thanks
    35
    Thanked 5 Times in 5 Posts

    Future Dates in Fields (2000)

    I am constructing a template with a date field that is (of course) updated every time the template is loaded.

    Is there a way to set that date field so that it is x number of days ahead of the current date? In essence, a "due date" out in the future?

  2. #2
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Future Dates in Fields (2000)

    I've done this by inserting a single cell Excel worksheet. The cell in the worksheet had the formula for the future date in it <font color=ff6666>=Today() + 30</font color=ff6666> as an example.
    egghead

  3. #3
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Future Dates in Fields (2000)

    There are several ways to do this and an add-in (free} available to construct such a field. The add-in can handle up to 28 days (given the vagaries of our Roman Empire calandar).

    The following is an example of a field that gives you the date two weeks from the day a document is created, in regular written English format:

    Creation date: July 9, 2001 - desired field result = July 23, 2001
    Creation date: July 23, 2001 - desired field result = August 6, 2001
    Creation date: December 20, 2001 - desired field result = January 3, 2002

    { QUOTE "{ SET Delay "14" }{ SET "DaysInMonth" { IF { CREATEDATE @ "MM" } <> 2 { = round(30.575*{ CREATEDATE @ "MM" },0)-ROUND(30.575*{ = { CREATEDATE @ "MM" } -1 },0) }{ IF { = MOD({ CREATEDATE @"yy" }, 4 ) } > 0 "28" "29" } } }{ SET "NextMonth" { IF { CREATEDATE @ "MM" } = 12 "1/97" "{ = { CREATEDATE @ "MM" } + 1 }/97 } }{ IF { = { REF Delay } + { CREATEDATE @ "dd" } } <= { DaysInMonth }{ CREATEDATE @ "MMMM { = { REF Delay} + { CREATEDATE @ "dd" } }, yyyy"}{ QUOTE { NextMonth @ "MMMM" } { = { REF Delay } + { CREATEDATE @ "dd" } - { DaysInMonth } }, { IF { } CREATEDATE @ "MM" } <> 12 { CREATEDATE @ "yyyy" }{ CREATEDATE @ "{ = 1 + { CREATEDATE @ "yyyy" } # "xxxx" }" } } } }" }

    <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>If this doesn't make your head spin, you're made of sturdy stuff! I wouldn't recommend trying to duplicate this by hand. This field was created by a downloadable Add-In created by Chris Woodman. I don't think you want to try to create such a field by hand. I have it in a document that you can download from my site if you want to play with it. There are also VBA solutions. The above field, two different links for the Add-In downloads, and some VBA solutions are found at <A target="_blank" HREF=http://www.addbalance.com/word/datefields2.htm> Calculated Dates in Word</A>.

    Hope this helps.
    Charles Kyle Kenyon
    Madison, Wisconsin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •