PDA

Click to See Complete Forum and Search --> : Crystal reports


sunny
Feb 22nd, 2000, 03:45 AM
please need help.....

Private Sub Command_Click()
CrystalReport.ReportFileName ="c:\Student.rpt"
CrystalReport.SelectionFormula = "{qdefCredOIAPRep.ExpiryDate}= 1/11/00 "
CrystalReport.Action = 1
End Sub

I am getting an error saying incorrect selection formula...please help me out..
sunny

SteveFlitIII
Feb 22nd, 2000, 07:35 PM
The format of the date may be incorrect try 11/11/1111 not just 1/11/11

rzarc
Feb 23rd, 2000, 08:50 AM
I think the format is in (YYYY,mm,dd)in using a crystal report.