Weekday function
 

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?

--

Thanks,
Dennis

Weekday function
 

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


"DENNIS BROWN" wrote in message . ..
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?

--

Thanks,
Dennis

Weekday function
 

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

--

Thanks,
Dennis
"Sue Mosher [MVP-Outlook]" wrote in message ...
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


"DENNIS BROWN" wrote in message . ..
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?

--

Thanks,
Dennis

Weekday function
 

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


"DENNIS BROWN" wrote in message . ..
But what if MyApp.Start contains something like
6/26/2007 9:35:00
Will it still process it?

--

Thanks,
Dennis
"Sue Mosher [MVP-Outlook]" wrote in message ...
The Weekday() function takes a date as its argument, so if myAppt is your appointment:

intDayOfWeek = Weekday(myAppt.Start)


"DENNIS BROWN" wrote in message . ..
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?