Calculate date with form field

[Mrs Dumm]

All,
I want to calculate a Return Date (date to return an evaluation by) from the
Evaluation Date (txtEvalDate).

"txtEvalDate" is a FormField set to Date format.

So, if "txtEvalDate" = April 2, 2008, I want "Return Date" to equal April 2,
2008 - 14 days which is March 19, 2008.

This is probably not as difficult as my brain seems to be making it. Help,
please!

Thanks,
Alicia (and yes, my last name really is Dumm... I married it... which means
I found a man "Dumm" enough to marry me!)

 

[macropod]

Hi Alicia,

To see how to do this and just about everything else you might want to do with dates in Word without the need for vba, check out my
Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Date and Time Calculations In A Word Form'. Since you want a fixed 14-day offset and your
formfield is named 'txtEvalDate', simply copy the field there, change 'FmDate' to 'txtEvalDate' and change the line '{SET Delay
{=FmDelay}}' to '{SET Delay 14}'.

Cheers

 

[Mrs Dumm]

Macropod,
I just discovered your site by accident on my own and I am overwhelmed with
the amount of awesome information you have! The ability to do this without
VBA and macros is extremely helpful in the network environment I'm in (darn
macro security... which we wouldn't need if Word wasn't so susceptible to
viruses!)

Thank you for your response and the links. I'll post back if I have any
further questions!

Alicia

Hi Alicia,

To see how to do this and just about everything else you might want to do with dates in Word without the need for vba, check out my
Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Date and Time Calculations In A Word Form'. Since you want a fixed 14-day offset and your
formfield is named 'txtEvalDate', simply copy the field there, change 'FmDate' to 'txtEvalDate' and change the line '{SET Delay
{=FmDelay}}' to '{SET Delay 14}'.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

All,
I want to calculate a Return Date (date to return an evaluation by) from the
Evaluation Date (txtEvalDate).

"txtEvalDate" is a FormField set to Date format.

So, if "txtEvalDate" = April 2, 2008, I want "Return Date" to equal April 2,
2008 - 14 days which is March 19, 2008.

This is probably not as difficult as my brain seems to be making it. Help,
please!

Thanks,
Alicia (and yes, my last name really is Dumm... I married it... which means
I found a man "Dumm" enough to marry me!)