Calculate date with form field

M

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!)
 
M

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
 
M

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

macropod said:
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]
-------------------------

Mrs Dumm said:
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!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top