Get the Day Name from a Date.

[paullem]

Hi,

I need to obtain a day name from a date so as to determine if the date is a weekday or weekend. Is there a function within Access to achieve this? I've had a look through the FAq's but couldn't see anything that may be relevant (unless I missed it).

Thanks,

paullem

 

[RoyVidar]

To get the name of the day, you can try the format function

? format(date, "dddd")

But there are other ways to work with this, too, for instance the weekday function

? weekday(date)

- note that default is that sunday is first day, for other, use

? weekday(date, vbMonday)

Roy-Vidar

 

[paullem]

Many thanks for that - the format function does exactly what I need.

paullem