Setting Date and Time

  • Thread starter Thread starter srm
  • Start date Start date
S

srm

I'm using O2003. / Due By field

For the initial value, I'm using Date() and it returns the current
date at 12:00 AM. If there a way to have it return the current date
and a set time or is there a setting I can change it from 12:00 AM to
another time?

Thanks.

Shawn
 
In the formula editor, under Functions, look under Date/Time. The DateAdd()
function there is what you should use. Here's an example to set the
date/time to today at 1 p.m.:

DateAdd("h", 13, Date() )
 
In the formula editor, under Functions, look under Date/Time. The DateAdd()
function there is what you should use. Here's an example to set the
date/time to today at 1 p.m.:

    DateAdd("h", 13, Date() )

--
Sue Mosher, Outlook MVP
   Author of Microsoft Outlook 2007 Programming:
     Jumpstart for Power Users and Administrators
   http://www.outlookcode.com/article.aspx?id=54
Click to expand...

Sue:

As always, thank you.

Shawn
 
Back
Top