A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Setting Date and Time



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 15th 09, 02:01 PM posted to microsoft.public.outlook.program_forms
srm
external usenet poster
 
Posts: 72
Default Setting Date and Time

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
Ads
  #2  
Old October 15th 09, 02:47 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP][_4_]
external usenet poster
 
Posts: 552
Default Setting Date and Time

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


"srm" wrote in message
...
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



  #3  
Old October 15th 09, 03:53 PM posted to microsoft.public.outlook.program_forms
srm
external usenet poster
 
Posts: 72
Default Setting Date and Time

On Oct 15, 8:47*am, "Sue Mosher [MVP]" wrote:
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

"srm" wrote in message

...

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


Sue:

As always, thank you.

Shawn
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook; setting time for end of activity should not change date. Martin, Leicester, UK Outlook - Calandaring 2 July 9th 08 04:25 AM
Meeting start date/time changes to current date/time Dave H Outlook - Calandaring 0 February 14th 08 03:18 PM
Setting not only due date but due time in Tasks Billy Outlook - General Queries 5 July 3rd 07 03:35 AM
Appointments display on date entered rather than date/time schedul MaxRPeterson Outlook - Calandaring 0 November 28th 06 05:49 PM
Setting a date/time field to 'NULL' dch3 Outlook - Using Forms 1 November 16th 06 09:43 PM


All times are GMT +1. The time now is 07:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.