请教:关于datetime问题
我用的是sql server库,CollectTime字段是DateTime类型,但
date1=date
date2=FormatDateTime(DateAdd("ww",-1,date1))
sql="select * from datebase where CollectTime<='"&date2&"'"
报错:The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
请教各位高手该怎么改?