Setting Date and Time

Status
Not open for further replies.
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() )

Sue Mosher

"srm" <srm@primatech.com> wrote in message

news:ccef3fe0-6a4b-4d39-9a6b-d12907770a79@p4g2000yqm.googlegroups.com...
> 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
 
On Oct 15, 8:47 am, "Sue Mosher [MVP]" <sue...@gmail.com> 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
>    >      >    
> "srm" <s...@primatech.com> wrote in message

> news:ccef3fe0-6a4b-4d39-9a6b-d12907770a79@p4g2000yqm.googlegroups.com...
>
> > 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
 
Status
Not open for further replies.
< Outlctl disabled (Outlook2007 SP2) | why outlook change forward mail >
Similar threads
Thread starter Title Forum Replies Date
J setting date in drafts Using Outlook 4
C date formulas / mathematics, setting a field one hour past another field value Outlook VBA and Custom Forms 1
V Setting up Outlook 2021 on new computer Using Outlook 2
AlphonseG Outlook 365 Outlook Crashes on setting SaveSentMessageFolder Outlook VBA and Custom Forms 4
R Outlook 2021 Having problem setting up outlook 2021 with windows 11. I have 3 gmail accounts and I want the 3 gmail, emails to merge into the same outlook input. Using Outlook.com accounts in Outlook 0
e_a_g_l_e_p_i Outlook 2010 Help setting up Gmail account in Outlook 2010 Using Outlook 3
P OWA Settings->Calendar->Events from Email; Setting changes do not hold Using Outlook 1
Marc2019 Setting up an Outlook Account on Mac Os 10.6.8 Outlook 2011 Using Outlook 1
L Outlook Office 365 client: won't remember my setting File, not to collapse ribbon Using Outlook 2
M Where is the setting to *turn off* open calendar in a new window? Using Outlook 3
llama_thumper Setting up forwarders on Exchange server Exchange Server Administration 0
B Setting rules Using Outlook 1
C iCloud Setting missing Outlook tab and Outlook missing the iCloud refresh button Using Outlook 4
B Setting defaults Using Outlook 2
C need help setting up outlook first time Using Outlook 1
P Reading Pane (Reading Pain?) Default Setting Using Outlook 1
W Setting up a custom form Outlook VBA and Custom Forms 2
mctabish Setting "Reply To" based on inbox Outlook VBA and Custom Forms 2
R Setting font and color used when replying to an email Outlook VBA and Custom Forms 3
M Setting flag follow up for next business day Outlook VBA and Custom Forms 1
Ed Sheehan Unusual behaviour in setting Sender (Outlook 2016) Outlook VBA and Custom Forms 4
Jennifer Murphy Equations don't comply with style setting to left justify Using Outlook 0
J Setting default address book Using Outlook 0
N Does a Shared Folder Policy override a Digital Signature Setting for macros? Outlook VBA and Custom Forms 6
Diane Poremsky Setting up an Outlook.com IMAP account Using Outlook 0
Diane Poremsky Setting the default Country for Outlook Contacts Using Outlook 0
H Need help setting up GetFolderPath-Makro with Vodafone IMAP Mail-Account Outlook VBA and Custom Forms 0
Diane Poremsky Adjusting Outlook's Zoom setting in Email Using Outlook 0
O Setting default format for composing/replying to emails Using Outlook 3
B Outlook Calendar/setting appointments Using Outlook 1
Diane Poremsky Adjusting Outlook's Zoom setting in Email Using Outlook 0
Diane Poremsky Setting Custom Reminder Times Using Outlook 0
A Can't stop Outlook.com from setting reminders on appointments? Using Outlook.com accounts in Outlook 3
A Setting RULES with more than one condition in MS OUTLOOK Using Outlook 6
L Setting up my PA's Outlook Using Outlook 7
E Need Help on Setting up a repeated Reminder on Task with Reoccurence Every Year Using Outlook 6
N "Instant Search" setting a default view Using Outlook 3
H SETTING UP A "NEW" NEVER HAD NEVER USED EMAIL ACCOUNT Using Outlook 9
K Setting Default Email Address for Meeting Replies Using Outlook 3
S Setting up Outlook 2010 to work with custom domain outlook.com account BCM (Business Contact Manager) 3
D Setting defult "Show a room list" Using Outlook 0
Horsepower Setting appointments in calendar Using Outlook 3
J Setting tabs in contacts / notes field Using Outlook 0
T Setting a Default Subject from a certain Signature Using Outlook 0
K Help Needed - setting up Email in Outlook 2013 Using Outlook 3
mikecox setting Default area code in Contacts Using Outlook 5
G Outlook2013 - "From" name doesn't change even when changed in Account Setting Using Outlook 4
D How do I start completely from scratch in setting up Outlook 2013? Using Outlook 6
V View zoom setting changing Using Outlook 1
C Setting up Outlook 10 on Widows 8 using Google Server Using Outlook 3

Similar threads

Back
Top