CrystalReports

i am getting an error when i use the following code

Dim x as date
ExDate = InputBox("Enter The Expiry Date")
x = CDate(ExDate)
CrystalReport.SelectionFormula = " month({qdefCredOIAPRep.EnteredDate})>0 and {qdefCredOIAPRep.EnteredDate}> x "

can anyone tell me the problem..please need help

[Glenn]

What line causes the error ? and what type of error are you getting ?

What line causes the error ? and what type of error are you getting ?

CrystalReport.SelectionFormula = " month({qdefCredOIAPRep.EnteredDate}) > 0 and {qdefCredOIAPRep.EnteredDate} > x "
CrystalReport.Action = 1

the error message is "error in the formula"

Edited by carlisle on 02-24-2000 at 06:21 PM