DateTimePicker and Crystal report

See more:

SQL-Server-2005

VB

SQL-Server

, +

Hi guys

I want to print a database table with Crystal Report.
In a form I have a DateTimePicker(dtpDate) and a button with this code

 Private Sub btnDayPrint_Click(sender As System.Object, e As System.EventArgs) Handles btnDayPrint.Click
        Dim Report As New frmReport
        objdata = New clsMSSQL
        isigroup = objdata.QueryDatabase("SELECT * FROM tblPlan WHERE plan_date >='" & dtpDate.Value.Date & "' ORDER BY plan_date")
        Myrpt.Load("..\..\Reports\Hmerisio.rpt")
        Call DataSourceConnection_Report()
        Report.Report1.ReportSource = Myrpt
        Report.Show()
    End Sub

Public Function QueryDatabase(ByVal Query As String) As DataTable
        Try
            Dim objDataSet As New DataSet
            Dim objDataTable As New DataTable
            Dim objDataAdapter As New SqlDataAdapter(Query, con)
            objDataAdapter.Fill(objDataSet, "DefaultTable")
            objDataTable = objDataSet.Tables("DefaultTable")
            con.Close()
            Return objDataTable
        Catch ex As Exception
            MessageBox.Show(ex.Message, "Λάθος", MessageBoxButtons.OK, MessageBoxIcon.Error)
            Return DbSwtable
        End Try
    End Function

The report opens but but the data shows it is not according to the date that I give with datetimepicker
What am I doing wrong ?

Thanks in advance

The table is PlanID INT, Tactic nvarchar, Rookies nvarchar, Borders nvarchar, plan_date datetime