asp提交出生日期进access的正确写法?

bluezcheng

请问asp提交出生日期进access的正确写法?
我的出生日期是这样的，
<select name="birthyear">
<option value=""></option>
<%dim i
for i = 1970 to 2008%>
<option value="<% = i%>"><%=i%></option>
<%next%>
</select>
年
<select name="birthmonth">
<option value=""></option>
<%for i = 1 to 12%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
月
<select name="birthday">
<option value=""></option>
<%for i = 1 to 31%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
日

然后在process是这样写的

<%
set rs=server.createobject("adodb.recordset"
sql="select * from try"
rs.open sql,conn,1,3

birthyear=request("birthyear"
birthmonth=request("birthmonth"
birthday=request("birthday"


rs.addnew
rs("username"=request("username"
rs("password"=request("pwd1"
rs("firstname"=request("F_name"
rs("lastname"=request("L_name"
rs("gender"=request("_gender"
rs("birthday"=dateofbirth=(birthyear &"-"& birthmonth &"-"& birthday)错误在这行
rs("date"=now
rs.update

rs.close
set rs=nothing

conn.close
set conn=nothing

response.redirect("success.asp"
%>


希望各位高手能指点一下小弟正确的写法是怎样的，先谢了?