Day of week of any date

[Stephen English]

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

 

[Stefan Blom]

Try this:

Dim dtMeeting As Date
Dim strDay As String

dtMeeting = "25/10/2006"

strDay = Format$(dtMeeting, "dddd")

--
Stefan Blom
Microsoft Word MVP


in message
news[email protected]...

 

[Stefan Blom]

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.

--
Stefan Blom
Microsoft Word MVP


in message

 

[Stephen English]

Hi Stefan
Thank you for such a quick reply. I was just having a mental block!
Kind regards
Stephen

 

[Stefan Blom]

You are welcome.

--
Stefan Blom
Microsoft Word MVP


in message