[Solved] ASP.Net Crystral Report Error: A date-time is required here

Refer below formula and check.

"{datamaster1.PaymentStatus}='SUCCESS' and {datamaster1.paymentdate}>='" & Format(FromDate, "yyyy-MM-dd") & "' and {datamaster1.paymentdate}<='" & Format(ToDate, "yyyy-MM-dd") & "'"

also tried with that but not working

now using this method and its working

Dim connectionString As String = connstring
Dim query As String = "SELECT * FROM datamaster where datamaster.PaymentStatus='SUCCESS' and datamaster.paymentdate>='" & Format(FromDate, "yyyy-MM-dd") & "' and datamaster.paymentdate<='" & Format(ToDate, "yyyy-MM-dd") & "'"
Using connection As New OdbcConnection(connectionString)
    Using adapter As New OdbcDataAdapter(query, connection)
        Dim dataSet As New DataSet()
        adapter.Fill(dataSet, "datamaster")
        Dim crystalReport As New Summary
        crystalReport.SetDataSource(dataSet)
        crystalReport.Refresh()
        CrptViewer.ReportSource = crystalReport