急!急!急!请教datetime问题!
想查date1至date2的记录写成:
year1=Cint(request.form("year1"))
mon1=Cint(request.form("mon1"))
year2=Cint(request.form("year2"))
mon2=Cint(request.form("mon2"))
date1=FormatDateTime(DateSerial(year1,mon1,1))
date2=FormatDateTime(DateSerial(year2,mon2,30))
set con=application("Cn")
set rs=server.createobject("adodb.recordset")
sql="Select Content,Subject from DocumentInfo where IssueTime between '"&date1&"' and '"&date2&"'"
rs.open sql,con
显示出错:
Microsoft OLE DB Provider for SQL Server error '80040e07'
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
到底该怎么写?请指教!