weekday function

D

Dave

Hi, does anybody know how to use the 'weekday function'
in order to return the day of week e.g. MONDAY from a
date field?
 
H

Henry

-----Original Message-----
Hi, does anybody know how to use the 'weekday function'
in order to return the day of week e.g. MONDAY from a
date field?


.
Try: WeekdayName(Weekday(Date))
Click to expand...
 
D

Douglas J. Steele

Henry said:
Try: WeekdayName(Weekday(Date))
Click to expand...

Or, for older versions of Access that don't have WeekdayName, you can use
Format$(Date(), "ddd") to get Mon, Tue, Wed, etc. or Format$(Date(), "dddd")
to get Monday, Tuesday, Wednesday, etc.
 
J

John Spencer (MVP)

Try the format function instead.

Format(SomeDate,"dddd") will return the name of the day for a date.
 
Top