When I run the following statement through the Query window in SQL I get records back:

select * from scheduledefine WHERE StartTime between "07:00" and "15:00"

When I run the same statement through a stored procedure I do not get any records back. The problem is when the records were inserted in the database they were inserted with the default date of "1900-01-01 07:00:00.000" and when the parameters are passed to the stored procedure as adDBTimeStamp the default date is "18991230 07:00:00:000". Any suggestions are welcome.

[Edited by AngelaMicikas on 11-07-2000 at 10:22 AM]