I have an Excel sheet with CDate and MDate as two columns. CDate is formatted as YYYY/MM/DD and MDate as YYYY/MM/DD HH:MI AM/PM<BR><BR>Now, I need to retrieve the data from the excel sheet based on the given condition. How do I format the string entered by the user and parse it as a query to be used with ADODB.Recordset ?<BR><BR>I have checked using isDate function whether the entered value is a Date or not .... But how to send it so that the SQL gets executed without any difficulty.<BR><BR>Any help please....rather urgent help please