苗景云的博客

 dateDiff用法

rs.Open "Select * From Hetong Where Purview like '%"&Session("CRM_name")&"%'  and dateDiff('d',JLTime,now)<8 Order By hId desc",conn,3,1

instr的用法

<% If instr(rs("viewuser"),Session("CRM_Name"))>0 Then %>