|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
July 25th 07, 10:41 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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 
|
|
#2
July 26th 07, 12:25 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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 news 
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
|
|
#3
July 26th 07, 01:34 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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 news
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
|
|
#4
July 26th 07, 02:01 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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 news
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?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Getting Weekday in AppointmentItem | DENNIS BROWN | Outlook and VBA | 1 | June 21st 07 08:10 PM |
| how to print same weekday over many months | [email protected] | Outlook - Calandaring | 0 | May 7th 07 10:09 PM |
| Weekday not showing | George Hill | Outlook - Calandaring | 2 | July 7th 06 03:51 AM |
| How do I set Calendar Recurrence of 1st and 3rd weekday of the mo. | Mark V. | Outlook - Calandaring | 2 | June 27th 06 01:37 PM |
| Outlook should have a recurrence option of fifth weekday(and more | johnnythehat | Outlook - Calandaring | 2 | March 12th 06 10:47 PM |
Hybrid Mode
