|
| 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
March 18th 09, 09:46 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
date formulas / mathematics, setting a field one hour past another field value
I am creating a custom outlook form in Outlook 2007 and need to set the value
of a date/time field in a control equal to 1 hour more than the date/time field in another control. These are the appointment start and end times. I need the end time control (and thus the end time field) to automatically set itself to one hour past whatever the start time control (an thus start time field) is set to by the user, because these must be 1 hour appointments. FYI, I have the drop down list of both of these controls set in 30 minute increments, if that makes a difference. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...forms/200903/1 
|
| Ads |
|
#2
March 18th 09, 11:17 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
date formulas / mathematics, setting a field one hour past another
What's your question? Are you asking how to write a formula that returns a
date/time an hour later than another date/time? Use the DateAdd() method for that, for example: DateAdd("h",1,[NameOfFirstField]) "cmonroe21 via OfficeKB.com" wrote: I am creating a custom outlook form in Outlook 2007 and need to set the value of a date/time field in a control equal to 1 hour more than the date/time field in another control. These are the appointment start and end times. I need the end time control (and thus the end time field) to automatically set itself to one hour past whatever the start time control (an thus start time field) is set to by the user, because these must be 1 hour appointments. FYI, I have the drop down list of both of these controls set in 30 minute increments, if that makes a difference. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...forms/200903/1
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to make a field with a "date dropdown field" | Wouter WES | Outlook - Using Forms | 3 | October 15th 08 12:35 PM |
| Date field | prog | Outlook - Using Forms | 2 | May 17th 07 02:47 PM |
| Setting a date/time field to 'NULL' | dch3 | Outlook - Using Forms | 1 | November 16th 06 08:43 PM |
| How do I know what formulas to use for setting up new emails ? | Louie | Outlook - General Queries | 2 | February 4th 06 09:17 PM |
| date fields - link the calander pop-up to a custom date field | Tom | Outlook - Using Forms | 0 | January 23rd 06 09:13 PM |
Linear Mode
