Date to Day of Week

[futebol3]

Does anyone know how to take a given date (eg. 12/12/2006) and convert this to a day of week (eg. Tuesday)?

I havent seen this in any previous posts and any thoughts would be greatly appreciated.

Thanks.

 

[AlexCuse]

WeekdayName(Weekday([my_date]),False)

Basically, you need to first return weekday number (weekday(my_date)), then get WeekdayName from that.

Hope this helps.

Alex

Ignorance of certain subjects is a great part of wisdom

 

[SkipVought]

Hi,

MsgBox Format([MyDate], "ddd")  'DOW abbreviation
MsgBox Format([MyDate], "dddd")  'DOW FULL

Skip,

_[red][/red]

 

[futebol3]

Thanks guys thats exactly what I needed. I appreciate the help.

 

[AlexCuse]

Skip - you are the man when it comes to dates. I did not know you could do that...

Alex

Ignorance of certain subjects is a great part of wisdom