求一SQL查询语句，在线等

[ajianchen2002]

我有一组记录，其中有日期字段，日期的格式为2004-9-9
比如我想查询出2004年9月份的记录
那么SQL语句怎么写呢
我在程序中用LIKE 语句怎么写呢？
StrDate = txtYearPay.Text & "-" & cboMonthPay.Text

Set rsWorking = New ADODB.Recordset
rsWorking.Open "select * from workingtable where 编号='" & cboEmployeeID.Text & " 'and 完成日期 like '" & StrDate% & "'", db, adOpenStatic, adLockOptimistic
运行时提示
类型-声明字符与声明的类型不符

请教高手这个问题怎么解决
非常感谢

[Andy__Huang]

2004-9-9 的格式與2004-10-9是不一樣的，所以要化所統一格式才好辦。
2004-9-9轉化成2004-09-09,每個日期都是10位婁。

sql="select * from workingtable where 编号='" & cboEmployeeID.Text & " 'and 完成日期 like '" & convert(varchar(7),日期,120) & "%'",

[RUKYO]

StrDate = Format(txtYearPay.Text, "0000") & "-" & Format(cboMonthPay.Text, "00")

Set rsWorking = New ADODB.Recordset
rsWorking.Open "select * from workingtable where 编号='" & cboEmployeeID.Text & " 'and 完成日期 like '%" & StrDate & "%'", db, adOpenStatic, adLockOptimistic

[of123]

StrDate1 = format(txtYearPay.Text & "-" & cboMonthPay.Text & "-01","yyyy-mm-dd")
StrDate2 = Format(DateAdd("m", 1, strDate1) - 1,"yyyy-mm-dd")
rsWorking.Open "select * from workingtable where 编号='" & cboEmployeeID.Text & " 'and 完成日期 Between #" & StrDate1 & "# And #" & StrDate2 & "#", db, adOpenStatic,

[harryho]

rsWorking.Open "select * from workingtable where 编号='" & cboEmployeeID.Text & " 'and 完成日期 >=#" & StrDate1 & "# 完成日期<= #" & StrDate2 & "#", db, adOpenStatic,