select * from [tablename]
rs.open sql,conn,1,1
if rs.Eof Then
response.Write("kong")
response.End
Else
do while not rs.eof
nr=rs("nr")
y1=year("qsrq")
y2=year(now)
m1=month("qsrq")
m2=month(now)
d1=day("qsrq")
d2=day(now)
y=(y2-y1)
yd=y*365
m11=12-m1
m21=12-m2
mm=m21-m11
if mm>1 Then
mmm=mm*30
End if
..........................
后面的自己想,懒的写了,其实不是这么复杂的
md=y*