MS Access retrieve record by compare datetime.Today to datetime in my data base column

See more:

C#

I try to select some records from my database by a column ho is Date/Time format compared with Datetima.Today. Im my database my format date time is "01/31/2014 07:10 PM", i wnat om my select to separate the date from time.

this is mi code. he gives no error but return 0 record.

Program.Connection.CommandText = "select SUM(PretVanzare) AS PretVanzare, IIF(CatProdus Is Null, 0, CatProdus) AS CatProdus FROM ProduseVandute WHERE DataVanzare=@DataVanzare GROUP BY CatProdus";
                Program.Connection.AddParameter("@DataVanzare", DateTime.Today);
                DataTable TableNirProduseVandute = new DataTable();
                Program.Connection.FillDataTable(TableNirProduseVandute, true);

                decimal[] SoldProduseVandute = new decimal[TableNirProduseVandute.Rows.Count];
                int[] CatProdusNrVandut = new int[TableNirProduseVandute.Rows.Count];

                for (int i = 0; i < TableNirProduseVandute.Rows.Count; ++i)
                {
                    SoldProduseVandute[i] = Convert.ToDecimal(TableNirProduseVandute.Rows[i]["PretVanzare"].ToString());
                    CatProdusNrVandut[i] = Convert.ToInt32(TableNirProduseVandute.Rows[i]["CatProdus"].ToString());
                }