Question [}Syntax error (missing operator) in query expression '29/03/2012 09:19:00'

[Manny123]

[XCODE]
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database genk.mdb;")
cn.Open()

Dim firstname, lastname, productID, quantityb, customerID, price, updatequantity As String
Dim OrderId As String
Dim purchasedate As Date = Now
firstname = txtFNM.Text
lastname = txtLNM.Text
productID = txtpIDsold.Text
quantityb = txtQb.Text





str = "Insert into Customer_Order (ProductID, CustomerID, Quantity_bought, Order_Date) values (" & productID & "," & customerID & "," & quantityb & "," & purchasedate & ")"
cmd = New OleDbCommand(str, cn)
exe = cmd.ExecuteNonQuery [/XCODE]


I get a Syntax error (missing operator) error when i try to input default date&time into my database through the variable 'purchasedate'. The Order_Date is stored as Date/Time data type in MS Access