Crystal report date record selection formula gives an error.

[former_member1007960]

I use the following code to feed a record selection formula to a report. I'm using VB.Net and MS SQL Server. "exp_date" is a date type column (Ex: 2021-10-25). getServerDateTime() is my own function to get the server date. "Impersonate" loads the login details to the report. I get the attached error when I'm running this code. What am I doing wrong here?

                Case "Expired Batches"


                    Dim crepExpIt As New crepExpiered
                    Dim curDate As Date = Format(getServerDateTime().Today)  
                    CReportAuthentication.Impersonate(crepExpIt) 
                    crepExpIt.RecordSelectionFormula = "{TB_STOCK.exp_date} <=#" & curdate & "#"
                    CrystalReportViewer1.ReportSource = crepExpIt
                    CrystalReportViewer1.Zoom(85)
                    CrystalReportViewer1.Refresh()
                    CrystalReportViewer1.RefreshReport()

[DellSC · Accepted solution]

I believe it needs single quotes as if it were a string instead of the #.

-Dell

[former_member1007960 · Accepted solution]

Thank you. It worked. But I use # at another formula and its working properly in that. Can u kindly explain why it isn't working here?

[DellSC · Accepted solution]

Is the other place where you're using it a date? Or is it another data type?

-Dell