My database currently holds a date column (dte)that is converted to a double subtype using "cdbl function". Need to convert back to date format using the following in order to produce report:

courtdate = Request.QueryString("crtdate")

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

Any help would be appreciated. I am new at this.

Mike

__________________
Mike

http://www.w3schools.com/vbscript/func_cdate.asp