In VB6 I'm trying to modify the fol

[dmccallum]

In VB6 I'm trying to modify the following to allow me to select data from VB6 instead of using the parameter in Crystal. But my date format is yyyymmdd as a string and this gives me an error message saying a string was expected here:

strSelectionFormula = "{JobCost.DateEntered} in String(" & _
Format(txtFromDate, "yyyy,mm,dd&quot & &quot to String(" & _
Format(txtToDate, "yyyy,mm,dd&quot & &quot"

crptduxford.ReplaceSelectionFormula strSelectionFormula)