Visual Basic query database using date time picker

See more:

VB

Hay guys having a big issue with this code, im trying to query a database and return all records which have the date inputted through the date time picker. No matter what I change and do (searched for a soultion for hours) nothing seems to work and keep getting Data type mismatch in criteria expression.

Imports System.Data.OleDb

Public Class ViewBookings
    Dim con As New OleDb.OleDbConnection
    Dim dbProvider As String
    Dim dbSource As String
    Dim ds As New DataSet
    Dim da As OleDbDataAdapter
    Dim sql_1 As String
    Dim sql_2 As String

Private Sub btnDate_Click(sender As Object, e As EventArgs) Handles btnDate.Click
        Dim editdate As date 
        dtpView.Value = Format(dtpView.Value.Date, "dd/MM/yyyy")
        editdate = dtpView.Value
        dbProvider = "PROVIDER=Microsoft.ACE.OLEDB.12.0;"

        dbSource = "Data Source =" & Application.StartupPath & "/Driving.accdb"

        con.ConnectionString = dbProvider & dbSource
        con.Open()


        sql_2 = "SELECT * FROM tblBookings WHERE LessonDate = '#" & editdate & "#' ORDER BY LessonDate DESC"

        da = New OleDbDataAdapter(sql_2, con)

        da.Fill(ds)

        dgBookings.DataSource = ds.Tables("query2")
        con.Close()
    End Sub
End Class