 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / October 2006Day of week of any date
Please can anyone tell me if there is a way of obtaining the day of the week from a date dtMeeting = 25/10/2006 strDay = DayofWeek(dtMeeting) I want it to return Wednesday in this case! Thanks Stephen Try this: Dim dtMeeting As Date Dim strDay As String dtMeeting = "25/10/2006" strDay = Format$(dtMeeting, "dddd")  SignatureStefan Blom Microsoft Word MVP > Please can anyone tell me if there is a way of obtaining the day of the week > from a date [quoted text clipped - 3 lines] > Thanks > Stephen Correction: It is best to assign the date value as a date literal. For example: dtMeeting = #10/25/2006# See more about date literals in VBA Help. SignatureStefan Blom Microsoft Word MVP > Try this: > [quoted text clipped - 13 lines] > > Thanks > > Stephen Hi Stefan Thank you for such a quick reply. I was just having a mental block! Kind regards Stephen > Try this: > [quoted text clipped - 13 lines] > > Thanks > > Stephen You are welcome. SignatureStefan Blom Microsoft Word MVP > Hi Stefan > Thank you for such a quick reply. I was just having a mental block! [quoted text clipped - 18 lines] > > > Thanks > > > Stephen
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.