How Do I display records between range of dates on Crystal Report

See more:

VB

CrystalReports

Private Sub btnsearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsearch.Click
Try
Dim con As New SqlConnection("Initial Catalog=stock;Data source=.\sqlexpress;integrated security=true;")
Dim da2 As New SqlDataAdapter("select * from stockentry where [Purchase Date] BETWEEN '" + comboBox1.Text + "'AND '" + ComboBox2.Text + "' order by[Purchase Date]", con)
Dim ds2 As New DataSet
da2.Fill(ds2)

CrystalReportViewer1.RefreshReport()
CrystalReportViewer1.SelectionFormula = "{stockentry.Purchase Date}= '" & comboBox1.Text & "' TO {stockentry.Purchase Date} = '" & ComboBox2.Text & "'"
CrystalReportViewer1.RefreshReport()

Catch ex As Exception
MsgBox(ex.Message)
End Try

End Sub


I get error and its not displaying between specific ranges. I use combo boxes