[thelist] Querystring Problem Somewhere! Where - I dotn know.

Luther, Ron Ron.Luther at COMPAQ.com
Tue Mar 5 12:06:01 CST 2002


Hi Paul,

Not sure of the syntax, but did you try a ToDate(x1) and ToDate(x2)?

HTH,

RonL.

-----Original Message-----
From: Paul Backhouse [mailto:paul.backhouse at 2cs.com]
x1 = AddThis & Day(Date) & "/" & AddThis2 & Month(Date) & "/" & Year(Date) &
" 00:00:01"
x2 = AddThis & Day(Date) & "/" & AddThis2 & Month(Date) & "/" & Year(Date) &
" 23:59:59"
strQuery2 = "SELECT Count(idate) AS Utotal FROM tblData WHERE idate BETWEEN
#"& x1 &"# AND #"& x2 &"#"
%>

<b>User Registered Today</b>: <%=objRS2("Utotal")%>




More information about the thelist mailing list