I'm trying to Select Data from an Access DB.
I wrote this query to Select all Invoices that were Invoiced between two dates.
I get the following error
Syntax error (missing operator) in query expression 'Invoiced >=02/01/13 AND <= 05/01/13'
"SELECT * FROM invoiced_filter WHERE Invoiced > " & fromdte & " AND < " & todte
Dim datefrom, dateto As Date
datefrom = Convert.ToDateTime(Trim(TextBox1.Text))
dateto = Convert.ToDateTime(Trim(TextBox1.Text))
Dim cmdload As New SqlCommand(("SELECT * FROM invoiced_filter WHERE invoiced BETWEEN '" & _
datefrom.Date & "' AND '" & _
dateto.Date & "'"), con.con)