Eric,

I'm not sure, but I would venture a guess that SQLServer isn't receiving the date string in a format it can do something with.

So here's an alternative: make your stored proc parameter a datetime (drop the convert), and call your proc by like this: GetEvents '20011023'. Note that if you always send a date as YYYYMMDD, SQLServer will always understand. (The single quotes are important)

HTH!

>Here is the code I use to execute it...
>
>strQuery = "GetEvents '" & srcDate & "'"
>Set objEventsRS = objEventsConn.execute(strQuery, ,adCmdStoredProc)