weekday function

[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?

 

[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))

 

[Douglas J. Steele]

Try: WeekdayName(Weekday(Date))

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.

 

[John Spencer (MVP)]

Try the format function instead.

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