smalldatetime convert error

[sallyme]

Hi I am passing Date value form .asp form like "3/15/2007"


And i am geting error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting character string to smalldatetime data type.



strSlq = "SELECT SUM(pieces) AS piecesTotal" _
& " FROM orders" _
& date_ordered > convert(datetime,'" & Dateordered & "',102)"
rs.Open strSql, cn

In MS SQL Server the Date_ordered field is smalldatetime, and stores the date values like 6/15/2007.

where do i convert what, I need help....pls

[jhardman]

you mean:

strSlq = "SELECT SUM(pieces) AS piecesTotal" _
& " FROM orders" _
&  " WHERE date_ordered > #" & convert(datetime, Dateordered ,102) & "#"
rs.Open strSql, cn

? Let me know if this works for you.

Jared

[Cintury]

Hi I am passing Date value form .asp form like "3/15/2007"


And i am geting error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting character string to smalldatetime data type.



strSlq = "SELECT SUM(pieces) AS piecesTotal" _
& " FROM orders" _
& date_ordered > convert(datetime,'" & Dateordered & "',102)"
rs.Open strSql, cn

In MS SQL Server the Date_ordered field is smalldatetime, and stores the date values like 6/15/2007.

where do i convert what, I need help....pls

I'm not 100% but you may want to change that strSlq on your first statement to be the same as that rs.Open strSql...