[AccessD] Day of week as name

stuart at lexacorp.com.pg stuart at lexacorp.com.pg
Wed Mar 29 21:21:17 CST 2006


On 29 Mar 2006 at 19:01, Joe Hecht wrote:
> 
> weekdayname(txtACCIDENT_dATE,,vbUseSystemDayOfWeek)
> 

Weekdayname takes a weekday number (1-7), not a date.

Use
Weekdayname(weekday(txtAccident_Date))
or 
Weekdayname(Datepart("w",txtAccident_Date))
or
Format(txtAccident_Date,"dddd")

-- 
Stuart





More information about the AccessD mailing list