What's wrong with my query string?

Hi, I am using a MS Access 2003 database file to connect to via my C-Sharp application. When I try to retrieve records from the database, I keep getting a "missing operator" error message. Here is my query string. string MySqlString = "SELECT * FROM Backups " + "WHERE (Backups.DATE_OF_BACKUP >= " + this.startDate + ") AND "+ "(Backups.DATE_OF_BACKUP <= " + this.endDate + ")"; The startDate and endDate are DateTime variables that contain dates in the following format: 1/28/2003 12:00:00 AM My biggest problem may be incorrect syntax when using a date value with MS Access 2003. Here is what MySqlString string holds after creating it: SELECT * FROM Backups WHERE (Backups.DATE_OF_BACKUP >= 1/1/2003 12:00:00 AM) AND (Backups.DATE_OF_BACKUP <= 1/28/2004 12:00:00 AM) Any help would be apprecciated! Thanks!

I hope I have not wasted anyone's time as I have found the answer. I did not find the answer in any documentation though. It was by trial and error. It turns out that MS Access requires '#' the pound character surrounding the date. I tried creating a query in Access to see if the syntax used would help me. I noticed that while in the "Query Designer" that when I typed a date in the "Criteria" section, MS Access would automatically surround the date with pound symbols (example: #1/23/2003#). So, I thought I would try the symbols in my query syntax. YAAAHOOOOOO IT WORKED! So here is the resulting code: string MySqlString = "SELECT * FROM Backups " + "WHERE (Backups.DATE_OF_BACKUP >= #" + this.startDate + "#) AND "+ "(Backups.DATE_OF_BACKUP <= #" + this.endDate + "#)";