PC Review


Reply
Thread Tools Rate Thread

Automatically Calculate Date field

 
 
=?Utf-8?B?SmlsbA==?=
Guest
Posts: n/a
 
      5th May 2005
I've created custom forms in Outlook 2003 and want to populate certain fields
with automatically calculated dates. For instance, if I put "May 1, 2005" in
the first field, "Contract Date," I want the following fields to populate
with the 'Contract Date' + X number of days. So the field Delivery Date
would automatically fill with the Contract Date plus 3 days, and the
Inspection Date would fill with Contract Date plus 10 days, and et cetera.

I'm doing something wrong. Can someone please tell me how to do this and
what formula to use? Thanks so much!!!
 
Reply With Quote
 
 
 
 
Sue Mosher [MVP-Outlook]
Guest
Posts: n/a
 
      5th May 2005
How about showing us what you've already done? [Contract Date] + 3 should be valid formula.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Jill" <(E-Mail Removed)> wrote in message news:A4DD3509-F5AF-4211-B83C-(E-Mail Removed)...
> I've created custom forms in Outlook 2003 and want to populate certain fields
> with automatically calculated dates. For instance, if I put "May 1, 2005" in
> the first field, "Contract Date," I want the following fields to populate
> with the 'Contract Date' + X number of days. So the field Delivery Date
> would automatically fill with the Contract Date plus 3 days, and the
> Inspection Date would fill with Contract Date plus 10 days, and et cetera.
>
> I'm doing something wrong. Can someone please tell me how to do this and
> what formula to use? Thanks so much!!!

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i calculate tomorrows date automatically? =?Utf-8?B?VGVja2k=?= Microsoft Access 3 12th Dec 2005 05:36 PM
How do I automatically calculate YTD numbers by changing a date? =?Utf-8?B?TURTaXN0YWg=?= Microsoft Excel Worksheet Functions 1 29th Apr 2005 05:52 PM
Automatically calculate a date in a control based on another date. =?Utf-8?B?QkFSS0FST08=?= Microsoft Access Forms 3 4th Nov 2004 12:42 AM
Date fields automatically changing when today date matches date field entry.Help! Brian Cassin Microsoft Access Forms 1 15th Nov 2003 01:51 PM
Calculate Date field Connie Microsoft Access 4 29th Jul 2003 04:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:03 AM.