How to filter from two dates to generate a data report in VB6
Posted on 2004-10-27
could any one help me on this.
I want to generate a data report filtered by two dates,
I currently use the following method to filter with one date.
Private Sub Command1_Click()
Dim sDate As String
sDate = Format(CDate(Text1), "mm-dd-yyyy")
'DataReport1.Orientation = rptOrientLandscape
DataReport1.Orientation = rptOrientLandscape
DataReport1.PrintReport True, rptRangeAllPages
Im using this SQL statement in DataEnvironments command1 properties.
SELECT flt, consignee, donumber, awbnumber, pkg, weight, examofficer, recname, remarks, `user`, serial, type, dodate FROM courier WHERE (dodate = ?)
Datatype : adDate
host data type :Date(VT_DATE)
This method works to filter by one date.
I couldnt figure out a way to filter it by two dates!!!!