Adding a number to a date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicole Vitale - 12 Sep 2005 15:01 GMT

I have a date field called {SaleDate \@ "MMMM d, yyyy"}. I need to add
14 days to that date and have it return as a date in my document.

For example, if {SaleDate \@ "MMMM d, yyyy"} = September 1, 2005, then I
need to return the date September 15, 2005 in my document. Is this possible?

I would appreciate any help. Thank you!

Sincerely,

Nicole Vitale

Reply to this Message

Anne Troy - 12 Sep 2005 17:13 GMT

Nicole, somebody's got a very cool tool that Charles Kenyon posts on his
site:
(Gotta scroll down some on the page)
http://addbalance.com/word/datefields2.htm
************
Anne Troy
www.OfficeArticles.com

> I have a date field called {SaleDate \@ "MMMM d, yyyy"}. I need to add
> 14 days to that date and have it return as a date in my document.
[quoted text clipped - 8 lines]
>
> Nicole Vitale

Reply to this Message

Graham Mayor - 13 Sep 2005 06:34 GMT

This is very complicated to do using fields, but still possible. Most of the
work has been done for you at
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 . Substitute your
SaleDate field for the Date field in the appropriate calculation and set the
date format where indicated.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> I have a date field called {SaleDate \@ "MMMM d, yyyy"}. I need to
> add 14 days to that date and have it return as a date in my document.
[quoted text clipped - 7 lines]
>
> Nicole Vitale

Reply to this Message