Need to convert courtdate variable to CDBL type. If anybody has an idea please point me in the right direction.

<----- CODE ----->
courtdate = Request.QueryString("crtdate")

ctdate = cdbl(courtdate)<---------- this is not working right now.

Set objConn = Server.CreateObject("ADODB.Connection")
strConnection = "Provider=SQLOLEDB;Data Source=acnt4;Initial Catalog=diary;User Id=sa;Password=;"
objConn.Open strConnection

Set objRs = Server.CreateObject("ADODB.Recordset")
Set objRs.ActiveConnection = objConn

Sql = "SELECT dte, eTime, cnumber, text_field, defatty, etype "
Sql = Sql & "FROM diary "
Sql = Sql & "WHERE dte= '" & dt & "' "
objRs.Open Sql, objConn

Mike

__________________
Mike

Cdbl(expression) Your expression should be numeric or something (not a string) that can be cast to a number.

This works
<%
Response.Write Cdbl(Now())
%>

but, This should not work
<%
Response.Write Cdbl("01/18/2005")
%>