I am trying to grab the purchase orders from my database that took place on todays date.

My query looks like this:
VB Code:
  1. Dim cnn As New SqlConnection(strCon)
  2.         Dim cmd As New SqlCommand
  3.         Dim da As New SqlDataAdapter
  4.         Dim ds As New DataSet
  5.         'Try
  6.         cmd = cnn.CreateCommand
  7.         cmd.CommandText = "SELECT " & _
  8.             "PurchaseOrders.CreationDateTime," & _
  9.             "PurchaseOrders.StoreID," & _
  10.             "PurchaseOrders.PurchaseOrderNumber," & _
  11.             "PurchaseOrders.VendorCode," & _
  12.             "PurchaseOrderItems.ItemCode," & _
  13.             "PurchaseOrderItems.Description," & _
  14.             "PurchaseOrderItems.VendorItemCode," & _
  15.             "PurchaseOrderItems.VendorUnitCode," & _
  16.             "PurchaseOrderItems.VendorOrderQuantity," & _
  17.             "Stores.AddressLine1, Stores.City," & _
  18.             "Stores.State, Stores.ZipCode " & _
  19.             "FROM PurchaseOrderItems INNER JOIN " & _
  20.             "PurchaseOrders ON PurchaseOrderItems.PurchaseOrderID = " & _
  21.             "PurchaseOrders.PurchaseOrderID INNER JOIN " & _
  22.             "Stores ON PurchaseOrders.StoreID = Stores.StoreID " & _
  23.             "WHERE PurchaseOrders.PurchaseOrderStatusCode = 'Ordered' AND (" & _
  24.             "PurchaseOrders.VendorCode = 'Spartan Oil Corporation' OR " & _
  25.             "PurchaseOrders.VendorCode = 'Vesco Oil Corporation' OR " & _
  26.             "PurchaseOrders.VendorCode = 'Polymer Dynamics' OR " & _
  27.             "PurchaseOrders.VendorCode = 'Mighty Auto Parts East') AND " & _
  28.             "PurchaseOrders.CreationDateTime >= " & "2/19/2007 10:21:00 AM"
  29.         da.SelectCommand = cmd
  30.         da.Fill(ds, "Orders")
  31.         dgvOrders.DataSource = ds
  32.         dgvOrders.DataMember = "Orders"
In that huge query the last item in the Where Clause is what I am having trouble with. I just want to pull Purchase orders that were made on the current days date. The database is SQL Server and the field is a DateTime Field. I am sure it is the way I have set the date but that is how it is set up in the SQL table.