How to Compute Future Date in Outlook Contact

[Guest]

I have designed an outlook contact form and am having a heckofatime getting
the form to recognize a future date.

Basically have two separate fields, both type date/time: Date of Injury &
Date to Complete Care

All I want to do is put in date of injury (i.e. 3/1/06) and have it
automatically calculate Date to Complete Care to one (1) year in the future.
So Date to Complete Care would be automatically 2/28/07.

I have tried the validate formula of ([DateofInjury] + 1Y) but it keeps
giving me today's date plus one (1) year. Even if I input 11/10/06 for the
date of injury I still get a Date to Complete Care of today's date + 1Y.

Having a tough time with this. Thanks for your help in advance.

 

[Sue Mosher [MVP-Outlook]]

Use the DateAdd() function in a value formula (not a validation formula):

dateadd("m", 12, [DateofInjury])

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers