ACCESS日期函数实例

ACCESS日期函数实例 星期:Weekday([日期])-1 中文星期:IIf(Weekday(表1!日期)=1,"星期日",IIf(Weekday(表1!日期)=2,"星期一",IIf(Weekday(表1!日期)=3,"星期二",IIf(Weekday(表1!日期)=4,"星期三",IIf(Weekday(表1!日期)=5,"星期四",IIf(Weekday(表1!日期)=6,"星期五",IIf(Weekday(表1!日期)=7,"星期六"))))))) 年第几周:Format([日期],"yyyy-ww") 第几周:Format([日期],"ww") 第季度:"第"&D