|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
April 7th 06, 12:32 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
How to Compute Future Date in Outlook Contact
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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "DieSpammersDie" wrote in message news:MTE0Mjc0MTA2OS5hbnRpZ29uZQ.1142741069@nulluse r.com... 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. 
|
| Ads |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I get calendar entries to synchronize with multiple compute | RS | Outlook - Calandaring | 2 | March 6th 06 01:51 AM |
| I cannot enter reminders in Outlook calendar 2003 for the future? | Leighanne | Outlook - Calandaring | 0 | February 16th 06 12:01 PM |
| Outlook shows all future appointments as cancelled.. | axn | Outlook - Calandaring | 0 | January 23rd 06 02:07 PM |
| How do I insert a date into the Outlook contact text box | BarryL | Outlook and VBA | 2 | January 20th 06 02:33 AM |
| Outlook displays past but not future holidays. How to resolve? | gb | Outlook - Calandaring | 1 | January 16th 06 05:26 PM |
Linear Mode
