Passing a Date to a stored procedure 1

[fpgiv]

Hi,
I'm new to using stored procedures, and I want to pass a date as a parameter. I'm using ASP, and my function call looks like:
et_uiteststartend 147,1, 6/17/2004, 1/6/2005

When I execute this function, I get the error Incorrect syntax near '/'.

Can anyone help?
Thanks!

 

[JohnDTampaBay]

Wrap the dates in single quotes. SQL will implicitly convert the string to a date as long as its in one of the acceptable formats. Check out dates, formats in BOL.

et_uiteststartend 147,1,'6/17/2004','1/6/2005'

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[fpgiv]

Thanks!