How to Compute Future Date in Outlook Contact

G

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.
 
S

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
 

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

Similar Threads

how to calculate hrs flown in last one year 0
Query to extract count on weekly basis for year 1
Validation formula in a form I created. 2
Rogue future date field highlighting 3
Excel PRICE function: How does it compute Issue Date of the Security 5
How to calculate a Future Date? 1
Select row by ID to nearest date, future (or past if no future dat 4
Subtracting 1 year from todays date 9

Top