Dear Everyone,
I have designed the Report manually & in a Command button on a form
I have written
Code:
Dim sStartDate As Date
Dim sEndDate As Date
Dim sSQL As String
sStartDate = Format(DTPicker1.Value, "dd/mm/yyyy")
sEndDate = Format(DTPicker2.Value, "dd/mm/yyyy")
sSQL = "select * from Sales where SellDate BETWEEN " & sStartDate & " and " & sEndDate
DataEnvironment1.Partsale sStartDate, sEndDate
frmPSale.Show
The Report returns all Records Beyond the dates I entered !!!
I am using CrystalReports XI R2
Is there anyone who can help me with this?please...
Pls help
Rahul