Weekday function

D

DENNIS BROWN

When using the Weekday function, can I use a string, and if so, what format?
I have to retrieve the needed date from the Start property of an appointment item, but what format will I need to convert the string to in order to get the Weekday function to work?
 
S

Sue Mosher [MVP-Outlook]

The Weekday() function takes a date as its argument, so if myAppt is your appointment:

intDayOfWeek = Weekday(myAppt.Start)

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


When using the Weekday function, can I use a string, and if so, what format?
I have to retrieve the needed date from the Start property of an appointment item, but what format will I need to convert the string to in order to get the Weekday function to work?
 
D

DENNIS BROWN

But what if MyApp.Start contains something like
6/26/2007 9:35:00
Will it still process it?

--

Thanks,
Dennis
The Weekday() function takes a date as its argument, so if myAppt is your appointment:

intDayOfWeek = Weekday(myAppt.Start)

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


When using the Weekday function, can I use a string, and if so, what format?
I have to retrieve the needed date from the Start property of an appointment item, but what format will I need to convert the string to in order to get the Weekday function to work?
 
S

Sue Mosher [MVP-Outlook]

Why not try it and see for yourself? Just type this into the Immediate window in VBA and press Enter:

? Weekday(#6/26/2007 9:35:00#)

TIP: The way to become productive and knowledgeable writing any kind of code is to experiment on your own.

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


But what if MyApp.Start contains something like
6/26/2007 9:35:00
Will it still process it?

--

Thanks,
Dennis
The Weekday() function takes a date as its argument, so if myAppt is your appointment:

intDayOfWeek = Weekday(myAppt.Start)


When using the Weekday function, can I use a string, and if so, what format?
I have to retrieve the needed date from the Start property of an appointment item, but what format will I need to convert the string to in order to get the Weekday function to work?
 
Top