The answer really depends on where you are passing the dates from. If you are passing the dates from a stored procedure you must use the CAST() function to convert the variable to proper datatype. If you are passing it from a VB component or ASP the you will need to use the CDate() function to convert the variable to proper datatype. If neither of these are a quick fix, I would focus on validating that you are passing the a variable with the proper datatype. VB and VBScript have other conversion functions that you may want to consider.<BR><BR>hope this helps <BR><BR>bart
I am sorry, i did not esplain my problem clearly. SQL Server will not take a hardcoded date, let alone a variable. Here's my hardcoded attempt:<BR> strSQL = "SELECT * FROM tblDailyReport WHERE ReportDate like ' 8/24/2000'"<BR> strSQL =strSQL & " ORDER BY location "<BR> RS.Open strSQL,Conn <BR><BR>SQL Server returns an empty recordset, not any error messages. Any advice?