Filtering a table based on a ‘Date/Time’ type field

See more:

C#

Hello,

I have a table (in Access) shown in a DataGridView Control. The table consists of some fields including a filed of the "Date/Time" type called "Date". I want to filter the table, based on this field. Although it sounds trivial, it raises an error saying that:

There is a syntax error (missing operator) in query expression "Date = 2010/07/11 12:00:00 AM".
I used the code below. Could you please let me know what is wrong with the code?

Thank you a lot

using System.Data.OleDb;


private void Form1_Load(object sender, EventArgs e)
        {
            string path = @"E:\Data\Myoffice\Access\";
            string DataBase_Name = "MyDataBase.accdb";
            string Table_Name = "Book";
            string Sql_Comnd = "select * from " + Table_Name + " Where  Date = 2010/07/11 12:00:00 AM";

            OleDbConnection con = new OleDbConnection();
            con.ConnectionString = con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = " + path + DataBase_Name;
            
            OleDbDataAdapter da = new OleDbDataAdapter( Sql_Comnd , con);
            DataSet ds = new DataSet();
            con.Open();
            da.Fill(ds, Table_Name);
            dataGridView1.DataSource = ds.Tables[Table_Name].DefaultView;
            con.Close();
        }