D Dave Aug 17, 2003 #1 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?
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 Aug 17, 2003 #2 -----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...
-----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 Aug 17, 2003 #3 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.
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) Aug 17, 2003 #4 Try the format function instead. Format(SomeDate,"dddd") will return the name of the day for a date.
