Convert a string to a date?

[marydn]

I have a textbox on an ASP page requesting a date. I then pass that date on to a stored procedure. The preocedure uses a cursor and performs several subqueries and inserts the values into a SQL table. I then create a recordset off the data in the table. However, I get the following error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Can anyone tell me what this means and how I can accomplish my task?

THANKS!!!!!!!!!!

 

[Bastien]

if IsDate(txtValue) then
' do some code
else
'spilt the entry and replace the month and day
'do the IsDate check again
end if
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[marydn]

I used your code and it helped me - the date is not the problem any more. My SQL table updated nicely. However, I am still receiving the above error! I am done skinning cats - I am going to take out the chicken!

Thanks!

 

[Bastien]

you may want to separate the subqueries from the insert...with no code it is hard to evealate what you are trying to do. wanna show me yours?

Bastien

There are many ways to skin this cat,
but it still tastes like chicken