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

  • Thread starter cmonroe21 via OfficeKB.com
  • Start date
C

cmonroe21 via OfficeKB.com

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.
 
S

Sue Mosher [MVP]

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top