How to delete a tuble by selecting a date

Thanks

The code should be like that

public string DeleteWatchReceipt(DateTime date)
{
OleDbConnection conn = new OleDbConnection("My DB path"));


string sqlinsert = @"DELETE WatchreceiptID FROM Watchreceipt WHERE Dato = @date";
conn.Open();
OleDbTransaction sqltrans = conn.BeginTransaction();
OleDbCommand cmdinsert = conn.CreateCommand();

cmdinsert.Parameters.AddWithValue("@date", date);

string result = null;

try
{

cmdinsert.CommandText = sqlinsert;
cmdinsert.Transaction = sqltrans;

cmdinsert.ExecuteNonQuery();
sqltrans.Commit();

result = "Ok";
}
catch (OleDbException odbe)
{
sqltrans.Rollback();
System.Windows.Forms.MessageBox.Show("Rolled back\n" + odbe.Message);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Systemfejl\n" + ex.Message);
}
finally
{
conn.Close();
}

return result;
}