<%
Set rsygdl1 = Server.CreateObject("ADODB.Recordset")
rsygdl1.open"SELECT * FROM yuangongbumenbiao WHERE bumenbianhao = '"&mybm&"' and DateDiff(d,'"&Request.form("nian")&"-"&Request.form("yue")&"',ruzhishijian)<=0 and DateDiff(d,'"&Request.form("nian")&"-"&Request.form("yue")&"',lizhishijian)>=0 ORDER BY xingming DESC",MM_xlgk_STRING,1,1
%>
目的是提取某在职员工的列表，大于入职时间，小于离职时间的员工。提取日的能够提到，但是月的提不到。
麻烦大神帮忙看看，问题何在？

<%
Set rsygdl1 = Server.CreateObject("ADODB.Recordset")
rsygdl1.open"SELECT * FROM yuangongbumenbiao WHERE bumenbianhao = '"&mybm&"' and DateDiff(m,'"&Request.form("nian")&"-"&Request.form("yue")&"',ruzhishijian)<=0 and DateDiff(m,'"&Request.form("nian")&"-"&Request.form("yue")&"',lizhishijian)>=0 ORDER BY xingming DESC",MM_xlgk_STRING,1,1
%>
目的是提取某在职员工的列表，大于入职时间，小于离职时间的员工。提取日的能够提到，但是月的提不到。
麻烦大神帮忙看看，问题何在？

不好意思，问题发错了，是m