Simple date function

  • Thread starter Thread starter Brett
  • Start date Start date
B

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
 
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
 
Brett said:
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
Click to expand...
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
 
Hollis D. Paul said:
Brett said:
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
Click to expand...
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
Click to expand...

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