只不過要改為年是
user_age = year(now())-year(rs("birthday") )
<%
connstr="DBQ="+server.mappath("./DATA.MDB")+";DefaultDir=;DRIVER={Microsoft Access
Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
set rs=server.createobject("adodb.recordset")
conn.open connstr
sql="select * from USERS"
rs.open sql,conn,3,3
'取得生日年齡
user_age = year(now())-year(rs("birthday") )
rs.close
set rs=noting
conn.close
set conn=nothing
%>
下面是調用年齡
妳的年齡是:<%=user_age%>