Weekday function

  • Thread starter Thread starter DENNIS BROWN
  • Start date Start date
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?
 
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?
 
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?
 
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?
 
Back
Top