date formulas / mathematics, setting a field one hour past another field value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cmonroe21 - 18 Mar 2009 22:46 GMT

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.

Reply to this Message

Sue Mosher [MVP] - 19 Mar 2009 00:17 GMT

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])

> 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
[quoted text clipped - 4 lines]
> I have the drop down list of both of these controls set in 30 minute
> increments, if that makes a difference.

Reply to this Message