What's wrong with my query string?

Question

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 = 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!

crausch · Answer

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 + #);