Simple date function

[Brett]

I'm new to programming Outlook forms so please forgive me for this
simple question. I have a date field in my form that needs to take the
current date and add 3 days and populate the field. How do I do this?
Thanks so much

 

[Sue Mosher [MVP]]

You can use this formula:

Date() + 3

to set the value of the field.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

 

[Hollis D. Paul]

I'm new to programming Outlook forms so please forgive me for this
simple question. I have a date field in my form that needs to take the
current date and add 3 days and populate the field. How do I do this?
Thanks so much

From and earlier message:
*************
You want to use a Date/Time field for the input, not a text box, and a
second Date/Time field for the date plus 30 display. In the Date plus
30 field, define a formula that takes the value of Date1 and adds 30 to
it, and set it to compute all the time (not sure how that is phrased).
You may have to break the formula into a date part and a time part.
Make sure both controls are bound to fields.
***************

Instead of 30, you should just use 3.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

 

[Brett]

I'm new to programming Outlook forms so please forgive me for this
simple question. I have a date field in my form that needs to take the
current date and add 3 days and populate the field. How do I do this?
Thanks so much

From and earlier message:
*************
You want to use a Date/Time field for the input, not a text box, and a
second Date/Time field for the date plus 30 display. In the Date plus
30 field, define a formula that takes the value of Date1 and adds 30 to
it, and set it to compute all the time (not sure how that is phrased).
You may have to break the formula into a date part and a time part.
Make sure both controls are bound to fields.
***************

Instead of 30, you should just use 3.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

Thanks for your help. The Date() + 3 worked great.