Фильтрация между двумя datepicker и двуми time picker

private void button7_Click(object sender, EventArgs e)
        {
            string conString = @"Provider=Microsoft.ACE.OLEDB.12.0;" + @"data source=";
 
            OleDbConnection conn = new OleDbConnection(conString);
            conn.Open();
            DataSet ds = new DataSet();
            string date1 = dateTimePicker3.Value.ToString("H:mm:ss").Replace('.', '/');
            string date2 = dateTimePicker4.Value.ToString("H:mm:ss").Replace('.', '/');
            OleDbDataAdapter adapter =
            new OleDbDataAdapter(String.Format("Select * from Table1 where clock_id Between #{0}# and #{1}#", date1, date2), conn);
            adapter.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            conn.Close();
            //string strSql = ("Select * from GGG where time_id >= '" + dateTimePicker1.Value.ToString("") + "' and time_id <='" + dateTimePicker2.Value.ToString("") + "'");  
        }
 
        private void button8_Click(object sender, EventArgs e)
        {
            string conString = @"Provider=Microsoft.ACE.OLEDB.12.0;" + @"data source=";
 
            OleDbConnection conn = new OleDbConnection(conString);
            conn.Open();
            DataSet ds = new DataSet();
            string date1 = dateTimePicker1.Value.ToString("MM/dd/yyyy").Replace('.', '/');
            string date2 = dateTimePicker2.Value.ToString("MM/dd/yyyy").Replace('.', '/');
            OleDbDataAdapter adapter = new OleDbDataAdapter(String.Format("Select * from Table1 where time_id Between #{0}# and #{1}#", date1, date2), conn);
            adapter.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            conn.Close();
        }

OleDbCommand cmd = new OleDbCommand("Select * from 'Table1' where 'clock_id' (Between @P1 AND @P2) AND 'time_id' (Between @P1 AND @P2)", con);
cmd.Parameters.Add(P1);
cmd.Parameters["P1"].Value = date1;
cmd.Parameters.Add(P2);
cmd.Parameters["P2"].Value = date2;