Use a parametrised query instead:
SqlDataAdapter com = new SqlDataAdapter("SELECT * FROM Farmers WHERE Date=@DT", con);
com..SelectCommand.Parameters.AddWithValue("@DT", dateTimePicker1.Value.Date);
DataSet ds = new DataSet("Farmers");
con.Open();
com.Fill(ds);
con.Close();