I am trying to search for a particular date from a report. When searching I have the following code
Set SelectField = VSelExpert1.GetField(1)
With SelectField
.FieldType = crDateTimeField
.FieldName = "ParkingHist.StartTime"
.AddValue "ParkingHist.StartTime"
End With
Set SelectRange = VSelExpert1.GetRange(1)
With SelectRange
Set SelectField = .SetRangeFieldByName("ParkingHist.StartTime"
.Operation = crSelectEqual ' crSelectEqual
.AddValue "14/08/2001 12:00:00"
End With
An error results saying that 'the ) is missing'
The search works for strings and integers. Does anybody know what's wrong?
Set SelectField = VSelExpert1.GetField(1)
With SelectField
.FieldType = crDateTimeField
.FieldName = "ParkingHist.StartTime"
.AddValue "ParkingHist.StartTime"
End With
Set SelectRange = VSelExpert1.GetRange(1)
With SelectRange
Set SelectField = .SetRangeFieldByName("ParkingHist.StartTime"
.Operation = crSelectEqual ' crSelectEqual
.AddValue "14/08/2001 12:00:00"
End With
An error results saying that 'the ) is missing'
The search works for strings and integers. Does anybody know what's wrong?