SET DATEFORMAT Dmy

I want to post a date and search a date

I posted 01/08/07 and it went into my database like this: 08/01/2007
then I posted 15/08/07 and it went in like: 15/08/07

I have put SET DATEFORMAT dmy in the INSERT INTO and SELECT SQL statements

now i get: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
/pubspace/events.asp, line 96

line 96: SET DATEFORMAT dmy SELECT * FROM members INNER JOIN (pubs INNER JOIN tEvents ON pubs.PubID = tEvents.PubID) ON members.UserID = tEvents.UserID WHERE Start_Date = '" & dDate & "' ORDER BY eventTime "